Loading into the Oracle Table(Column Data Type : CLOB)

vrsraju · Post by **vrsraju** » Tue Jun 29, 2004 2:23 pm

Hi
I am trying to load the Oracle table using a parallel job in which one of columns data type is CLOB. Data Stage is not recognizing this data type.
But I could be able to import the metadata using plug-in. The meata data is showing the data typa as Long VarChar(4000). But when I run the job, it fails. Could any one tell me how I can solve this problem?
I appreciate the help
Thank you
Venkat

chucksmith · Post by **chucksmith** » Tue Jun 29, 2004 3:02 pm

Do you need to load the column, if not, then delete it from your job.

vrsraju · Post by **vrsraju** » Tue Jun 29, 2004 5:05 pm

I need the column as this is one of the main column in the table but its not primary key or part of the key.

chulett · Post by **chulett** » Tue Jun 29, 2004 5:39 pm

vrsraju wrote:But when I run the job, it fails.

Fails how? How is your OCI output column defined and what are the error messages you receive?

vrsraju · Post by **vrsraju** » Wed Jun 30, 2004 6:54 am

I was trying to use Oracle Enterprise Stage

vrsraju · Post by **vrsraju** » Wed Jun 30, 2004 1:34 pm

I am getting the following error
ORAT_GFSTU48: Column UTL_ERROR_STRING has unsupported type.

DSXchange

Loading into the Oracle Table(Column Data Type : CLOB)

Loading into the Oracle Table(Column Data Type : CLOB)

Re: Loading into the Oracle Table(Column Data Type : CLOB)