Older Version worked for getting Byte[] from a oracle Blob, now does not

Older Version worked for getting Byte[] from a oracle Blob, now does not

Postby bgleber » Mon 19 May 2008 04:42

I'm not sure what version I was running, but I just purchased the new version of ORADirect.NET and I cannot seem to get the data out of an oracle blob inside a REFCURSOR.

I was calling in stored procedure that returned a REFCURSOR with a Blob in it. I would then read the cursor into a OracleDataReader and when I got to the Blog field, I would loop through all the attributes until I found the Byte[].

Well the Byte[] is no longer in the attributes. In fact, the field comes back as OracleObject which is null.

Any helpor other ideas to get this data would be appreciated.

Thanks!
bgleber
 
Posts: 1
Joined: Mon 19 May 2008 04:29

Postby Alexey.mdr » Tue 20 May 2008 09:31

Please send me (alexeyman*crlab*com) a small test project to reproduce the problem.
It is desirable to use 'test' schema objects, otherwise include the
definition of your own database objects.
Do not use third party components.
If it is impossible for you to create the test project, send us a piece of
your code where the error occurs.
Alexey.mdr
 
Posts: 729
Joined: Thu 13 Dec 2007 10:24


Return to dotConnect for Oracle