Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to insert value using case when and to_lob

User_7H0N0Feb 14 2022

I Have 2 Table which this schema.
image.pngimage.pngI want to insert value form table TEST_1 to TEST_2 and I want to check type of column TEST_RAW in table 1 to convert datatype.
I use this query but I found error Error: ORA-00932: inconsistent datatypes: expected - got LONG BINARY
image.pngimage.png
What should I do?

This post has been answered by Frank Kulash on Feb 14 2022
Jump to Answer
Comments
Post Details
Added on Feb 14 2022
4 comments
1,387 views