Reading BLOB data

rajesh223 · Post by **rajesh223** » Tue Jun 19, 2007 4:23 pm

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

JoshGeorge · Post by **JoshGeorge** » Tue Jun 19, 2007 7:15 pm

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)

Abburi · Post by **Abburi** » Tue Jun 19, 2007 7:27 pm

rajesh223 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

Search for BLOB Exact Match will get the information, hope this will help you

rajesh223 · Post by **rajesh223** » Thu Jun 21, 2007 3:53 pm

Hi JoshGeorge,
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)

rajesh223 · Post by **rajesh223** » Thu Jun 21, 2007 3:58 pm

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.

Abburi wrote:
rajesh223 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
Search for BLOB Exact Match will get the information, hope this will help you

chulett · Post by **chulett** » Thu Jun 21, 2007 6:03 pm

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?

rajesh223 · Post by **rajesh223** » Thu Jun 21, 2007 10:14 pm

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

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?

chulett · Post by **chulett** » Fri Jun 22, 2007 6:23 am

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.

DSXchange

Reading BLOB data

Reading BLOB data

Re: Reading BLOB data

Re: Reading BLOB data