Page 1 of 1
"oracle datatype not presently supported".
Posted: Fri Jun 13, 2008 11:13 pm
by Jagan617
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.
Posted: Sat Jun 14, 2008 1:23 am
by ArndW
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.
Posted: Sat Jun 14, 2008 5:31 am
by Jagan617
I cann't change the datatype, its coming from source itself.
Whats the alternative for this in datastage 7.5.1A?
Posted: Sat Jun 14, 2008 5:34 am
by Jagan617
I cann't change the datatype, its coming from source itself.
Whats the alternative for this in datastage 7.5.1A?
Posted: Sat Jun 14, 2008 6:42 am
by chulett
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?
Posted: Sat Jun 14, 2008 6:43 am
by ArndW
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.