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