On Nov 30, 10:32 pm, DA Morgan <damor...@[EMAIL PROTECTED]
> 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 Wa****ngton
> damor...@[EMAIL PROTECTED]
(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
(
Index FILLER position(1:2),
param1 BOUNDFILLER,
param2 BOUNDFILLER,
"DATA" "GetContent(:param1,:param2)"
)
I hope this helps.
|
