OCILobWrite returning SUCCESS_WITH_INFO

From: <zippyquick_at_my-deja.com>
Date: Tue, 28 Mar 2000 14:41:05 GMT
Message-ID: <8bqg9u$vpm$1_at_nnrp1.deja.com>



Using Oracle 8.15 on Solaris 2.6 writing in C.

I'm having no problems using the OCILobRead to retrieve data that is manually entered into the database. However, when attempting to write to the BLOB column using OCILobWrite, a SUCCESS_WITH_INFO value is returned. Because it is a form of "success", the error buffer is not populated and any call to OCIErrorGet just returns "OCI_NO_DATA" (because the buffer is empty).
I can't find any documentation on what the "INFO" I'm supposed to be getting is.

All handles appear to be allocated correctly and the size of the data (test purposes only) is very small.

Finally, even though a "SUCCESS_WITH_INFO" is returned, after a successful call to
OCITransCommit, it appears the BLOB column was NOT written to.

anyone got any ideas?
comments?

if u need more info I'll be happy to provide it :)

thx in advance

AcK

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Mar 28 2000 - 16:41:05 CEST

Original text of this message