#sql-status -Reply

[Jim Hardesty <jhardest@LMBERRY.COM>]

>>> Albert Howard <starbuckk@MAILROOM.COM> 12/03/99 04:51pm >>>
Most databases have a "Messages and Codes" reference.  #sql-status
should have the code number corresponding with the statement in
$sql-error.  The SQR Manual refers Oracle users to the "V2" status
code.
--------------------------------------------------------------------------------------------------------------------
Aye, there's the rub!

What are these Oracle V2 status codes and where do I find them?  They sound
great but they aren't in the Oracle7 Server Messages document.  I can't find a
reference to them in any of the Oracle7 documentation.  I've looked and looked,
maybe I'm just overlooking them.

Sorry to keeping asking the same question, but I've already RTFM.  Does
anybody have a specific RTFM manual suggestion?  :)

I can't believe no one has written conditional code using Oracle #sql-status
values.  (not sure why I'm suprised since we never bothered to either).

jim

-- Original Message As Follows --

Subject: #sql-status
From: Jim Hardesty <jhardest@LMBERRY.COM>
To: Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
Date: Fri, 3 Dec 1999 13:46:40 -0500

(Oracle 7.3 )

Does anyone have any documentation detailing what values end up in #sql
status
based on what error conditions in a begin-sql (duplicate key on insert,
unable to
delete, etc)?  The book just says that various appropriate values are
put into that
variable.  What would these values be?

The only one we know if that -9 means duplicate key in Oracle. What
about all the
other possible errors?

jim