Older Version worked for getting Byte[] from a oracle Blob, now does not
Posted: 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!
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!