Skip to Main Content

Oracle Database Discussions

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!

Insert as select with clob field.

user10931224Oct 15 2013 — edited Oct 15 2013

Oracle 11.2.0.3 on Linux.

I need to execute this insert as select:

INSERT INTO TAB1 (SQL_ID,SQL_FULLTEXT)

      SELECT DISTINCT t.sql_id, t.sql_text FROM DBA_HIST_SQLTEXT;

But I get this error:

ORA-00932: inconsistent datatypes: expected - got clob

This is TAB1:

SQL_ID          VARCHAR2(13)                          

SQL_FULLTEXT    CLOB         Y                        

SQL_CUSTOM_HASH VARCHAR2(60) Y         

Should I user dbms_lob package? Is so, I do not understand how.


Thanks

M.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 12 2013
Added on Oct 15 2013
2 comments
616 views