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!!
Reading CLOB data using ORACLE stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 41
- Joined: Wed Oct 08, 2008 9:19 am
-
- Participant
- Posts: 597
- Joined: Fri Apr 29, 2005 6:19 am
- Location: Singapore
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.
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.
Kandy
_________________
Try and Try again…You will succeed atlast!!
_________________
Try and Try again…You will succeed atlast!!
-
- Participant
- Posts: 41
- Joined: Wed Oct 08, 2008 9:19 am
Reading CLOB data using ORACLE stage
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..
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..
-
- Participant
- Posts: 597
- Joined: Fri Apr 29, 2005 6:19 am
- Location: Singapore
-
- Participant
- Posts: 47
- Joined: Fri Sep 23, 2005 6:01 pm