PROC-STATUS function

Returns the return status from a stored procedure. The return status is an INTEGER value that indicates whether a stored procedure failed and why.

Syntax

PROC-STATUS

Example

This procedure runs the ORACLE stored procedure pcust and writes the results of the stored procedure into the ABL-supplied buffer, proc-text-buffer. The CLOSE STORED-PROCEDURE statement then retrieves the output parameters. The return status is written to the variable iStat and is displayed. This same code works for accessing a stored procedure from an ODBC-compliant data source:

DEFINE VARIABLE iStat AS INTEGER NO-UNDO.

RUN STORED-PROCEDURE pcust (10, OUTPUT 0, OUTPUT 0).
FOR EACH proc-text-buffer:
END.
CLOSE STORED-PROCEDURE pcust iStat = PROC-STATUS.
DISPLAY iStat.

Notes

See also

CLOSE STORED-PROCEDURE statement, PROC-HANDLE function, RUN STORED-PROCEDURE statement