OCI errors and ORA-00000
From: Sundar Raman <cybertoast_at_mindless.com>
Date: Mon, 29 Nov 1999 22:39:30 +0900
Message-ID: <38428212.C9BCD104_at_mindless.com>
[Quoted] 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:
Date: Mon, 29 Nov 1999 22:39:30 +0900
Message-ID: <38428212.C9BCD104_at_mindless.com>
[Quoted] 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 - 14:39:30 CET