loading CLOB column using function
Date: Fri, 30 Nov 2007 12:28:15 -0800 (PST)
I am a newbie of sql loader. Everything seems to be fine until I hit a block road - the CLOB column type. I want to load data into the clob column using a stored function. I need to do some manipulation on the data before it gets saved to that column. But I got this error when I run the sql loader.
SQL*Loader-309: No SQL string allowed as part of "DATA" field specification
DATA is my CLOB type column.
Almost all the references are suggesting to use a file to load data on CLOB column but what I want to use a function in which it generates the content to be saved into the column.
Any help is greatly appreciated.
MISICompany Received on Fri Nov 30 2007 - 21:28:15 CET