Unload SQL Table data having CLOM Column
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
Re: Unload SQL Table data having CLOM Column
Have you looked at the DBMS_LOB package?
You should be able to use that package to parse the LOBS.