Re: OCI errors and ORA-00000

A bit more information - the return message to the below code is: (Database: sqluser) oparse failed (ORA-00000: normal, successful completion)

Don't know if this helps, but just thought I'd add it in case.

Thanks.

Sundar Raman wrote:

> I've got a problem that is cofusing me quite a bit. My program uses OCI
> 7.3 calls, such as oopen(), oparse(), obndrv(), etc. I've got a
> situation where my application crashes due to it thinking that an error
> has occurred in code like below:
>
> if (oparse (&(cursor.cda), sqluser, (sb4) - 1, DEFER_PARSE,
> (ub4)VERSION_7))
> {
> text msg[600];
> sword rv;
> rv = oerhms(cursor.lda, cursor.cda.rc, msg, 600);
> printf ("Database: sqluser "
> "oparse failed (%.*s)", FunctionName, WorkerID, rv, msg);
>
> if (oclose(&cursor.cda))
> {
> printf ("WARNING: %s: (WID %ld): (Database): "
> "oclose1 failed",
> FunctionName, WorkerID);
> }
> return(SQL_ERROR);
> }
>
> Problem is that the message code is ORA-00000 which should mean that no
> error happened. How is it that oparse() thinks that the call failed?
> Do I have to now do a check for the return status also, just to check to
> see if the call failed and if the return code is a success?
>
> Why is this the case?
>
> Thanks a lot for your help.
Received on Mon Nov 29 1999 - 08:22:59 CST