HP-UX AAA Server A.08.02 Administrator's Guide

Table 79 Return Values and Description for OCI and ODBC APIs
ODBCOCIReturn Values
SQL_SUCCESSOCI_SUCCESS0
SQL_SUCCESS_WITH_INFOOCI_SUCCESS_WITH_INFO1
SQL_NEED_DATAOCI_NEED_DATA99
SQL_NO_DATAOCI_NO_DATA100
SQL_ERROROCI_ERROR–1
SQL_INVALID_HANDLEOCI_INVALID_HANDLE–2
OCI_STILL_EXECUTING–3123
SQL_STILL_EXECUTING2
error code Native error codes from the database. For example, ORA-00000 for
success. You can configure this error code as 0. Other examples are 1,
17, and 18.
Following is an example to configure the SQL result mapping whose return
code is 0, error code is 0, and return event is ACK:
DBR (0:0) RET (ACK)
Following is an example to configure the SQL result mapping whose return
code is 0, error codes are 0,1, and 2, and return event is ERROR:
DBR (0:0,1,2) RET (ERROR)
NOTE: You can use wildcard to represent the return code and error code.
For more information on event names, see “Event Names ” (page 292).
NOTE: The DBR (ret code:error code) RET (ret event) is a new syntax. It offers
more options to customize your SQL result mapping.
Result Handling for Retrieval Requests
The default FSM expects an ACK event to indicate success with the exception of retrieving user
entries, where RETRIEVE_SUCCESS is expected. Use SQL result mapping with the
RetrieveonZero mapping function in your user retrieval actions as the last mapping entry in
the output map to set the event to RETRIEVE_SUCCESS.
Implementing SQL Access 267