Re: C program won't run in 9.0.2.3

Ruth,

Just to be clear you are pre-compiling(not compiling) under 9.0.2.3 and compiling with same C compiler then linking with new 9.0.2.3 libraties. OS is the same.
Obviously the contents of sqlca.sqlcode memory location is getting stomped on as 1093480496 is garbage. I would not think the sqlca data structure would change. I am assuming the code below is immediately following your EXEC SQL statement. Are you doing any select...into where you may be getting a buffer overflow. I know this is code that is probably unchanged and you just want to precompile/compile/link in new Oracle environment, these
are very hard to find.

Rick

                                                                                                                                       
                      "Ruth Gramolini"                                                                                                 
                      <rgramolini_at_tax.s        To:       Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>                   
                      tate.vt.us>              cc:                                                                                     
                      Sent by:                 Subject:  C program won't run in 9.0.2.3                                                
                      ml-errors_at_fatcity                                                                                                
                      .com                                                                                                             
                                                                                                                                       
                                                                                                                                       
                      08/29/2003 10:31                                                                                                 
                      AM                                                                                                               
                      Please respond to                                                                                                
                      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: rgramolini_at_tax.state.vt.us

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: ListGuru_at_fatcity.com (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: 
  INET: Rick_Cale_at_teamhealth.com

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: ListGuru_at_fatcity.com (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).