Ruth, First off there were two different error codes associated with "no data found", +100 and +1403. Depending on which you've mapped into SQL_NOT_FOUND you may be hitting the other. Also there is a BUG in the Pro*C and OCI interfaces listed on MetaLink. The symptom is that sqlca.sqlerrm.sqlerrmc returns "normal successful execution", but the sqlca.sqlcode returns -24391. Supposedly fixed in 9.0.2.4 patch set for HP-UX & Solaris only.
Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -----Original Message----- Sent: Friday, August 29, 2003 10:32 AM To: Multiple recipients of list ORACLE-L Good morning, We are trying to run a C program that runs on 8.0.6.3 after compiling it under 9.0.2.3 and we cannot get it to run. Does anyone know of any changes to the C interface with Oracle 9i that we should be aware of? The it errors out everytime when it tries to write an error message with the following lines: if ( sqlca.sqlcode != SQL_NO_ERROR ) { if (sqlca.sqlcode == SQL_NOT_FOUND ) return(-1) ; else { LogError_v("SQL ERROR (%d) : [%s]\n" , sqlca.sqlcode, sqlca.sqlerrm.sqlerrmc) ; return(-1) ; and the SQL Error is: SQL ERROR (1093480496) : [0: no data but there is data. Any help would be greatly appreciated!!!! Thanks in advance, Ruth Gramolini Oracle DBA Vermont Department of Taxes -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).