I have an attribute in table of type CLOB. I have extracted the data in text format and replaced carriage returns and line fields into other sets of characters so that I could afterwards upload the same data using SQL Loader.

When I tried to load the data I tried to perform another replace in the SQL Loader but got an error as follows:

SQL*Loader-309: No SQL String allowed as part of DETAILS field specificatiom.

The linein the loader that is failing is the following:

DETAILS POSITION(115) char(4000) TERMINATED BY '??||??' "replace(replace(replace(:details,'<CHR(10)>',CHR( 10)),'<CHR(13)>',CHR(13)),'<CHR(9)>',CHR(9))"