"oracle datatype not presently supported".

Jagan617 · Post by **Jagan617** » Fri Jun 13, 2008 11:13 pm

when accessing the oracle table which has column defined as BLOB datatype through oracle 8 stage in datastage 7.5.1A, i am getting the error
"oracle datatype not presently supported".

Pls can anyone help me in this.

ArndW · Post by **ArndW** » Sat Jun 14, 2008 1:23 am

Use another Data type. It seems that at V8 you can write CLOBs and BLOBs to Oracle using the enterprise edition, but you still cannot read them.

Jagan617 · Post by **Jagan617** » Sat Jun 14, 2008 5:31 am

I cann't change the datatype, its coming from source itself.
Whats the alternative for this in datastage 7.5.1A?

Jagan617 · Post by **Jagan617** » Sat Jun 14, 2008 5:34 am

I cann't change the datatype, its coming from source itself.
Whats the alternative for this in datastage 7.5.1A?

chulett · Post by **chulett** » Sat Jun 14, 2008 6:42 am

He means in the job, not in the database, in an effort to work around the simple fact that BLOBs are not officially supported. What datatype are you currently using?

ArndW · Post by **ArndW** » Sat Jun 14, 2008 6:43 am

Are you reading for writing? You might have to do what we did - lots of cast and substring operations in the SQL in order to break the large object into distinct 4Kb chunks that fit into supported data types.