CODEWITHSUNDEEP
oracle11glong-integerclob
Victor
Victor

Reputation: 17077

Oracle unable to convert from LONG datatype to CLOB datatype( incosistent datatype error)

Oracle 11g is giving me the following error while trying to convert a long datatype to a clob. I try: select to_lob(long_col_name) from table1. I get :

[Error] Execution (1: 39): ORA-00932: inconsistent datatypes: expected - got LONG

What am i doing wrong here?

Upvotes: 2

Views: 23046

Answers (4)

Manolete
Manolete

Reputation: 11

I suggest a workaround like this, hope this helps to somebody.

 SELECT substr(Y.longtoclob,
          43 + length('ALIASLONG'),
          DBMS_LOB.GETLENGTH(Y.longtoclob) -
          2 * (32 + length('ALIASLONG'))) longtoclob
  from dual,
   (select (dbms_xmlgen.getxml('SELECT t.column_long ALIASLONG 
  FROM TABLE_LONG_CLOB t WHERE t.id = 2')) longtoclob
      from dual) Y where DBMS_LOB.GETLENGTH(Y.longtoclob) > 0

Upvotes: 1

papa.kostas
papa.kostas

Reputation: 39

You can apply this function only to a LONG or LONG RAW column, and only in the select list of a subquery in an INSERT statement.

Upvotes: 3

burnDB
burnDB

Reputation: 54

You can't directly fetch LONG to LOB. You might want to convert it to VARCHAR2 first

Upvotes: 0

Victor
Victor

Reputation: 17077

Found the answer here with the help of a colleague: http://docs.oracle.com/cd/B19306_01/server.102/b14200/functions185.htm But no idea why this restriction is in place

Upvotes: 3

Related Questions