Re: loading CLOB column using function
Date: Mon, 3 Dec 2007 07:11:40 -0800 (PST)
[Quoted] [Quoted] On Nov 30, 10:32 pm, DA Morgan <damor..._at_psoug.org> wrote:
> Baldwin wrote:
> > Hi,
> > I am a newbie ofsqlloader. Everything seems to be fine until I hit a
> > block road - theCLOBcolumn type. I want to load data into theclob
> > 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 thesqlloader.
> >SQL*Loader-309: NoSQLstring allowed as part of "DATA" field
> > specification
> > DATA is myCLOBtype column.
> > Almost all the references are suggesting to use a file to load data on
> >CLOBcolumn 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
> damor..._at_x.washington.edu (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org- Hide quoted text -
> - Show quoted text -
here is the control file
INTO TABLE table1
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
[Quoted] Index FILLER position(1:2), param1 BOUNDFILLER, param2 BOUNDFILLER, "DATA" "GetContent(:param1,:param2)"
I hope this helps. Received on Mon Dec 03 2007 - 16:11:40 CET