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!

Problem exporting CLOB fields

pacoKASMay 12 2010 — edited May 12 2010

I need to export the values of a table containing a CLOB field.

I export these values as an INSERT like this...

INSERT INTO CLOB_TABLE (
CLOB_FIELD ) VALUES ( 'TEXT_VERY_VERY_LONG');

The problem...

I got a CORRECT INSERT instruction, because the field value is complete (not truncated) but...

SQL*PLUS doesn't work with this field as CLOB but a VARCHAR2, and when TEXT_VERY_VERY_LONG has a length greater than 4000 then fails...

What can I do to EXECUTE the insert properly?