Reading CLOB data using ORACLE stage

rohit_mca2003 · Post by **rohit_mca2003** » Tue Dec 23, 2008 1:00 pm

Hi,

I am trying to read the CLOB data type column using Oracle OCI stage. when I imported the metadata, it has given Longvarchar(4000) but after running the job is has aborted with the following error message:

Implicit conversion from source type "decimal[10,0]" to result type "string[max=4000]": Converting decimal to string.

I do not have any idea from where it is taking decimal(10). Could any one help me please in sorting this out.

Thanks in advance!!

kandyshandy · Post by **kandyshandy** » Tue Dec 23, 2008 1:18 pm

No !! Check again and see what is the stage name prefixing your error message "Implicit conversion from source type "decimal[10,0]" to result type "string[max=4000]": Converting decimal to string. "

If you are using a user defined SQL, then the order of columns in SELECT might be different than in columns tab.

Or

you are trying to map this CLOB field to a decimal field in target.

rohit_mca2003 · Post by **rohit_mca2003** » Tue Dec 23, 2008 2:21 pm

It is giving error in the Oracle stage only. I am taking oracle data into dataset.

I am not converting any data and just copying the oracle data.

I am not using user defined SQL.

I am using same metadata, what I have imported using metadata definition.

Also I am not mapping CLOB data to decimal.

Even I was surprised how it is happening.

Pls anyone help me..

kandyshandy · Post by **kandyshandy** » Tue Dec 23, 2008 7:29 pm

tell us your job design.

bharathappriyan · Post by **bharathappriyan** » Tue Dec 23, 2008 11:06 pm

Please use user defined SQL with cast function. The syntax is given below.
cast( '22-Aug-2003' AS varchar2(30)