Re: SQLCA.sqlcode values/meaning Cross-Reference in Pro*C

There are actually a whole bunch more.

Basically, it is whatever return code Oracle has designed. There is a manual, the Error Messages and Codes, which is about 3 inches thick, which lists them all.

You might consider includind sqlca.sqlerrm.sqlerrmc in any message display. This is the actual text of the error description.

In article <35adc18f.1297591708_at_news.brookes.ac.uk>,   p0070621_at_brookes.ac.uk (Tommy Wareing) wrote:
> On Wed, 15 Jul 1998 12:01:06 -0400, "Ramdrive"
> <SPAM_ME_NOTbob_kuhar_at_ccmail.sgo.sony.com> wrote:
>
> > "Every executable SQL statement reutrns
> >a status code in the SQLCA variable sqlcode, which you can check implicitly
> >with WHENEVER SQLERROR or explicitly with your own C code." At no point
> >does it go on to say if I wish to explicitly check it, where I look to find
> >out what the values mean.
>
> It is either set to 0 (for everything ok), or it's set to the error
> code returned:
> eg
> #define NO_DATA_FOUND 1403
> #define DUP_VAL_ON_INDEX -1
> #define TIMEOUT_ON_RESOURCE -51
> #define INVALID_CURSOR -1001
> #define NULL_PASSWORD -1005
> #define NOT_LOGGED_ON -1012
> #define LOGIN_DENIED -1017
> #define TOO_MANY_ROWS -1427
> #define ZERO_DIVIDE -1476
> #define INVALID_NUMBER -1722
> #define STORAGE_ERROR -6500
> #define PROGRAM_ERROR -6501
> #define VALUE_ERROR -6502
> #define CURSOR_ALREADY_OPEN -6511
>
> note that the NO_DATA_FOUND is dependant on the exact options that are
> supplied to the pre-compiler (ANSI mode produces +100, I think)
>
> --
> Tommy Wareing
> MIS Group
> Learning Resources
> Oxford Brookes University
> 01865 483389
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Thu Jul 16 1998 - 13:53:24 CDT