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.
"oracle datatype not presently supported".
Moderators: chulett, rschirm, roy
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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>