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
).