Reading CLOB data using ORACLE stage
Posted: 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!!
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!!