Reading BLOB by sql, in Oracle Database

Hi list,

Is there an universal way to read/change some blobs in an oracle database ? Or is it necessary to know the blob structure ?

Did someone knows a way to read blob in versions table (F983051) for example ?

Is it possible by sql to know on which data item are done data selections of batch versions ?

Thanks for your help.

Antoine.
OW system administrator.

Antoine

I believe blobs can only be read with C++ code. I couldn't tell you the structure of the versions blob. Perhaps you should post this question on the Developers forum.

Patty

It is not really possible to change the BLOB's without knowing the structure - but certain tools out there certainly can let you see the blobs embedded. Try looking at some of Quest Software's tools (not the JDE user group) ! There is also some shareware tools available if you look hard enough. I don't want to write which ones however.