General discussion


Oracle BLOB with ADO

By Divyesh ·
Hi All,
I have installed Oracle 8i server on one system and client on another system.
Now I creates two table as follows on server.

->Create table first (id number(2),data LONG RAW);
->Create table second (id number(2),data BLOB);

Now I am using MS Visual C++ and ADO to retrieve the values from those two tables from client with DSN.

Values from First table can be retrieved by "Select * from First". All OK.

But the problems in Second table. Even the open method for recordset fails. If I do not select the BLOB field then All works OK. But BLOB column can not be selected.

To solve my problem , send some suggestions.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by Ed Woychowsky In reply to Oracle BLOB with ADO

Had a simular problem, in my case the BLOB was bigger than 32K causing ADO .Net to choke. The work-around was to use ODP .Net as a provider, it allows for BLOBs of 2G. It is available as a download from Oracle.

Related Discussions

Related Forums