A_ORA_RETURN_SUCCESS_INFO

The Acu4GL/Oracle interface does not return a file error if a SQL operation results in an OCI_SUCCESS_WITH_INFO status code. The text associated with the status would however be printed to the error file if the application is run with tracing.

The A_ORA_RETURN_SUCCESS_INFO causes Acu4GL/Oracle to return an error 9D to the application on this status code. The application can then use the library routine C$RERR to retrieve additional information about the error.

A_ORA_RETURN_SUCCESS_INFO can be set to the following values:

  • If set to the default of FALSE, no file error returns to the application if Acu4GL receives a status code of OCI_SUCCESS_WITH_INFO. The text associated with the status code is however printed to the error file if the application is run with tracing.
  • If set to TRUE, a file status 9D returns to the application, which can then call C$RERR to return additional status codes and the text of the error message. The text associated with the status code is also printed to the error file if the application is run with tracing.