DSXchange

Posted: **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

Posted: **Tue Jun 29, 2004 3:02 pm**

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

Posted: **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.

Posted: **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?

Posted: **Wed Jun 30, 2004 6:54 am**

I was trying to use Oracle Enterprise Stage

Posted: **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)