My Oracle Support Banner

RDBPROD: How To Handle a SQLCODE of -1 in Rdb Applications (Doc ID 65376.1)

Last updated on JANUARY 03, 2019

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

To view full details, 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 a vibrant support community of peers and Oracle experts.