Re: loading CLOB column using function

Baldwin wrote:
> Hi,
>
> 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.
>
> Baldwin
> MISICompany

Without posting the control file no help is possible.

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org