Hi guys,

I have to unload a table into flat file .This table which is to be unloaded has a CLOB column.
Once unloaded into flat file-This flat file will be used to load data into another table having almost similar columns.

I did develop script like spooling this into a txt file :
SELECT
OID,',',
UNIQUE_CREATOR_ID,',',
ENTITY_ID_GLN,',',
INFO_PROVIDER_GLN,',',
SOURCE_DATA_POOL_GLN,',',
RECIPIENT_GLN,',',
GTIN,',',
DOCUMENT_CONTENT,',',..............CLOB Column
CREATION_USER_OID,',',
CREATION_DATE,',',
LAST_UPDATED_USER_OID,',',
LAST_UPDATED_DATE
FROM uccnet.IR_ROUTED_NOTIFICATION
where oid between 200 and 220

But when I use SQWL Loader to load data into another table having clob column it does not work.

I would appreciate if you could let me know, if there is another by which it could be done.
Thanks for all the help.

Bonny