Guys,
Please help me on this issue. I am trying to read BLOB data from Oracle database. Iam getting the following error while reading the BLOB data from oracle
"Internal Error: (colDesc):orautils.C: 1803: getColDesc failed"
Is there any solution for this issue.
Thanks in advance,
Rajesh
Reading BLOB data
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 612
- Joined: Thu May 03, 2007 4:59 am
- Location: Melbourne
I think BLOB (binary large object) is not a supported data type in 7x as such. Anyway you can try reading using to_char(BLOB_FIELD_NAME)) with LongVarChar (4000) (There is a column size limit for this also)
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
Re: Reading BLOB data
Search for BLOB Exact Match will get the information, hope this will help yourajesh223 wrote:Guys,
Please help me on this issue. I am trying to read BLOB data from Oracle database. Iam getting the following error while reading the BLOB data from oracle
"Internal Error: (colDesc):orautils.C: 1803: getColDesc failed"
Is there any solution for this issue.
Thanks in advance,
Rajesh
Hi JoshGeorge,
Thanks for your reply. Actually to_char doesn't work with the BLOB data, I have already tried on this.
Thanks,
Rajesh
Thanks for your reply. Actually to_char doesn't work with the BLOB data, I have already tried on this.
Thanks,
Rajesh
JoshGeorge wrote:I think BLOB (binary large object) is not a supported data type in 7x as such. Anyway you can try reading using to_char(BLOB_FIELD_NAME)) with LongVarChar (4000) (There is a column size limit for this also)
Re: Reading BLOB data
Hi Abburi,
When I search "BLOB" i got n number of message. I have already dig into these message. Anyway tnx for ur reply.
Thanks,
Rajesh L.
When I search "BLOB" i got n number of message. I have already dig into these message. Anyway tnx for ur reply.
Thanks,
Rajesh L.
Abburi wrote:Search for BLOB Exact Match will get the information, hope this will help yourajesh223 wrote:Guys,
Please help me on this issue. I am trying to read BLOB data from Oracle database. Iam getting the following error while reading the BLOB data from oracle
"Internal Error: (colDesc):orautils.C: 1803: getColDesc failed"
Is there any solution for this issue.
Thanks in advance,
Rajesh
Hi chulett,
The requirement is to substring the BLOB data into specific length.
Eg:
source field
Column1 (datatype BLOB)
Target
Column2 = Column1[1:50]
only one solution i need is, to convert the BLOB data to char format.
Thanks,
Rajesh L
The requirement is to substring the BLOB data into specific length.
Eg:
source field
Column1 (datatype BLOB)
Target
Column2 = Column1[1:50]
only one solution i need is, to convert the BLOB data to char format.
Thanks,
Rajesh L
chulett wrote:What are you planning on doing with this BLOB field? There's no 'transformations' you can do on it and (as you are finding) they aren't really supported. What is your goal and does this really need to be accomplished with an ETL job?
Errr, ok. If this was a CLOB you would be golden. However, being a BLOB or Binary Large Object I'm not sure there's a way to 'convert to char' in any kind of meaningful way.
Whatever you need to do will need to happen in the source select. If you are on 10g then look into the use of the DBMS_LOB.SUBSTR function. Otherwise, take DataStage out of the equation and ask your DBA how they would do something like this.
Whatever you need to do will need to happen in the source select. If you are on 10g then look into the use of the DBMS_LOB.SUBSTR function. Otherwise, take DataStage out of the equation and ask your DBA how they would do something like this.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers