RDBPROD: How To Handle a SQLCODE of -1 in Rdb Applications

(Doc ID 65376.1)

Last updated on AUGUST 03, 2016

Applies to:

Oracle Rdb Server on OpenVMS - Version 5.1 and later
HP OpenVMS VAX
HP OpenVMS Alpha
HP OpenVMS Itanium

Goal

When an application returns a SQLCODE of -1, more error handling must be performed to understand the cause of the error. A SQLCODE of -1 does not have a specific meaning. In the "SQL Reference Manual", Appendix C, there is a list of SQLCODE values and what their meanings. Additional error trapping can be very helpful in other scenarios as well, and Rdb Support recommends calling SQL_GET_ERROR_TEXT or SQL$SIGNAL any time the returned SQLCODE is less than 0. 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms