Conversion from LONG RAW to BLOB in Oracle

0

I tried to use TO_LOB to convert the value LONG RAW to insert but it returns:

  

ORA-00932 inconsistent datatypes tips

The destination is a column BLOB of a table already in use of the system, and its type can not be changed with ALTER MODIFY , the solution was to create a NEW intermediate table with the BLOB column to serve and only after performing the INSERT in the Final Table with the equal column types ( BLOB ).

    
asked by anonymous 04.04.2017 / 21:14

0 answers