Re: loading CLOB column using function

[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

LOAD DATA
INFILE 'temp.csv'
REPLACE
INTO TABLE table1
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
(

[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