RE: C program won't run in 9.0.2.3
Thanks, Peter! We have solved the problem now. Glad for the help, tho! Regards, Ruth -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Pete Finnigan Sent: Monday, September 01, 2003 8:44 AM To: Multiple recipients of list ORACLE-L Subject: Re: C program won't run in 9.0.2.3 Hi Ruth Try running under truss or equivalent and check what libraries are being linked in, maybe you have linked against an incorrect ORACLE_HOME?. Also I have seen a similar issue going from 7.3.4 to 8.0.6 a long time back but if I remember correctly it was caused by a previous printf statement with incorrect number of format args called before the place there was a similar error to yours. We could only assume at the time that the different Pro*C libs / calls built a slightly different stack / heap and caused the overwrite to happen in a different place between versions. It could of course be a bug in Pro*C, check metalink? hth kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan 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: 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).
Re: C program won't run in 9.0.2.3
Hi Ruth Try running under truss or equivalent and check what libraries are being linked in, maybe you have linked against an incorrect ORACLE_HOME?. Also I have seen a similar issue going from 7.3.4 to 8.0.6 a long time back but if I remember correctly it was caused by a previous printf statement with incorrect number of format args called before the place there was a similar error to yours. We could only assume at the time that the different Pro*C libs / calls built a slightly different stack / heap and caused the overwrite to happen in a different place between versions. It could of course be a bug in Pro*C, check metalink? hth kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan 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).
C program won't run in 9.0.2.3
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).
RE: C program won't run in 9.0.2.3
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).
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
[EMAIL PROTECTED]To: Multiple recipients of list
ORACLE-L [EMAIL PROTECTED]
tate.vt.us cc:
Sent by: Subject: C program won't run in
9.0.2.3
[EMAIL PROTECTED]
.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: [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:
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).
