Error in extracting records having CLOB datatype.
Moderators: chulett, rschirm, roy
Error in extracting records having CLOB datatype.
Hi All,
I have a problem , i hope you guys could help me on this. I am having problem in extracting records from Oracle table where one of the column has CLOB datatype. I am using Oracle Enterprise stage . Target column also has the datatype as CLOB. I tried using longVarchar in datastage still wouldnt work . Do you guys have any idea.
thanks in advance . i appreciate your help
I have a problem , i hope you guys could help me on this. I am having problem in extracting records from Oracle table where one of the column has CLOB datatype. I am using Oracle Enterprise stage . Target column also has the datatype as CLOB. I tried using longVarchar in datastage still wouldnt work . Do you guys have any idea.
thanks in advance . i appreciate your help
Regards,
Deepu
Deepu
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
as you might know that datastage doesn't support clob datatypes and there is no default conversion from clob to any other datatype.
You have to convert it to some other datatype in your SQL query itself say varchar2 or something else.
You have to convert it to some other datatype in your SQL query itself say varchar2 or something else.
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.![Wink :wink:](./images/smilies/icon_wink.gif)
Genius may have its limitations, but stupidity is not thus handicapped.
![Wink :wink:](./images/smilies/icon_wink.gif)
-
- Participant
- Posts: 437
- Joined: Fri Oct 21, 2005 10:00 pm
What version of DataStage are you using? The Oracle Connector has the ability to reference an LOB data type -- at least in 8.5 and above. I can't remember if 8.0 or 8.1 had this capability.
Keith Williams
keith@peacefieldinc.com
keith@peacefieldinc.com
-
- Participant
- Posts: 437
- Joined: Fri Oct 21, 2005 10:00 pm
I knew from your previous you are using the Oracle Enterprise Stage. Do you have the Oracle Connector and could you try that instead? Your requirement is to move data, not to move it with a particular stage.
Keith Williams
keith@peacefieldinc.com
keith@peacefieldinc.com
Talk to someone you work with that can help - DBA, Architect, whomever.
Google can also help as well. For example, a search for "oracle cast clob to varchar2" returns many results, including this one from the perennial favorite Ask Tom.
Google can also help as well. For example, a search for "oracle cast clob to varchar2" returns many results, including this one from the perennial favorite Ask Tom.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers