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

bgleber · Post by **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!

Alexey.mdr · Post by **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.