| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Wrong values in sqlca.sqlcode, SQLCODE, and SQLSTATE
A copy of this was sent to Burkhard Schultheis <bschultheis_at_tde.ra.eunet.de>
(if that email address didn't require changing)
On Thu, 01 Oct 1998 16:18:42 +0200, you wrote:
>Hello everybody,
>
>I'm developing with the following environment:
>DEC UNIX V4.0,
>Oracle V7.3.2.1.0
>
>Here is my test program:
>
>EXEC SQL INCLUDE sqlca;
>
>EXEC SQL BEGIN DECLARE SECTION;
> char *uid = "lzgneu/lzg";
> long SQLCODE;
> int a;
>EXEC SQL END DECLARE SECTION;
>
> char SQLSTATE [6];
>
>void main (void)
>{
> EXEC SQL CONNECT :uid;
>
> printf ("sqlca.sqlcode: %ld, SQLCODE: %ld, SQLSTATE: %s\n",
> sqlca.sqlcode, SQLCODE, SQLSTATE);
>
> EXEC SQL SELECT * INTO :a FROM lzgneu.test;
> printf ("sqlca.sqlcode: %ld, SQLCODE: %ld, SQLSTATE: %s\n",
> sqlca.sqlcode, SQLCODE, SQLSTATE);
>}
>
>Table test is created as
>Create table test (a integer);
>Table test is empty.
>
>I compiled this program with
>proc sqlcheck=full userid=lzgneu/lzg auto_connect=yes mode=ansi
>iname=test.pc
>and
>cc -Wl,-rpath,/db/oracle/lib -o testoracle -g
>-I/db/oracle/precomp/public -L/db/oracle/lib -lclntsh -ldnet_stub test.c
>
>The output from this program is as follows:
>
>sqlca.sqlcode: 0, SQLCODE: 0, SQLSTATE:
>sqlca.sqlcode: 3544382665317613593, SQLCODE: 3544382665317613593,
>SQLSTATE:
>
>Why I get so silly values? I have checked sizeof (sqlca.sqlcode): 8. Who
>
try using:
CFLAGS=-O2 -Olimit 4500 -std1 -DOSF1 -DA_OSF -Wf,-readonly_strings -D_INTRINSICS -w1 -misalign
I think, if i remember, the important ones are -DOSF1 and -DA_OSF .... Otherwise you get a mixture of 64bit ints and 32bit ints (which is what you are seeing right now)....
>can help?
>Thank you!
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA
--
http://govt.us.oracle.com/ -- downloadable utilities
Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Thu Oct 01 1998 - 12:40:27 CDT
 |
 |