SQLCA interface

You can use db_SQLCA/2 predicate to access the SQLCA for error reporting or other services.

db_SQLCA(Comm, Res)

Where Comm is any one of the below and Res is the result from Oracle.

• SQLCODE: The most recent error code
• SQLERRML: Length of the most recent error msg
• SQLERRMC: The error msg

eg. | ?- db_SQLCA('SQLERRD'(2), Rows).

returns in Rows number of rows processed by the most recent statement.

For SQLCAID, SQLCABC,SQLERRP, 'SQLERRD'(0) to 'SQLERRD'(5), 'SQLWARN'(0), to 'SQLWARN'(5),'SQLEXT' see ORACLE's C PRECOMPILER user's manual.