Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Very big values in sqlca.sqlcode

Re: Very big values in sqlca.sqlcode

From: Kalpana Vora <kvora_at_us.oracle.com>
Date: Fri, 09 Oct 1998 16:28:53 -0700
Message-ID: <361E9C35.E6981BB6@us.oracle.com>

If an error occurs, a negative value is returned. Make sure you C variable is a signed variable.

Burkhard Schultheis wrote:

> I use %ld too!
>
> John Strange schrieb:
>
> > how are printing the number.
> >
> > I use %ld
> >
> > Burkhard Schultheis (bschultheis_at_tde.ra.eunet.de) wrote:
> > : In a C program I get the value 0 in sqlca.sqlcode if nothing went wrong.
> > : But if an error occurs I get very big values in sqlca.sqlcode. For
> > : example:
> > : sqlcode is 3472325071279685656 for error OR-00100: not data found. What
> > : is wrong?
> >
> > : --
> >
> > : Burkhard Schultheis
> > : Tele Data Electronic
> >
> > --
> > While Alcatel USA may claim ownership of all my ideas (on or off the job),
> > Alcatel USA does not claim any responsibility for them. Warranty expired when you
> > opened this article and I will not be responsible for its contents or use.
>
> --
>
> Burkhard Schultheis
> Tele Data Electronic
Received on Fri Oct 09 1998 - 18:28:53 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US