Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Oracle Tools > loading CLOB co...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 5 Topic 2676 of 2769
Post > Topic >>

loading CLOB column using function

by Baldwin <ibaldwinjr@[EMAIL PROTECTED] > Nov 30, 2007 at 12:28 PM

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
 




 5 Posts in Topic:
loading CLOB column using function
Baldwin <ibaldwinjr@[E  2007-11-30 12:28:15 
Re: loading CLOB column using function
DA Morgan <damorgan@[E  2007-11-30 19:32:01 
Re: loading CLOB column using function
Baldwin <ibaldwinjr@[E  2007-12-03 07:11:40 
Re: loading CLOB column using function
DA Morgan <damorgan@[E  2007-12-03 11:02:32 
Re: loading CLOB column using function
Baldwin <ibaldwinjr@[E  2007-12-03 11:18:05 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Sun Jul 6 18:10:51 CDT 2008.