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 

For descriptions of the possible values for the return status of a non-ABL stored procedure, see the procedure’s documentation.

For more information on using this function, see the OpenEdge DataServer Guides (OpenEdge Data Management: DataServer for Microsoft SQL Server, OpenEdge Data Management: DataServer for ODBC, and OpenEdge Data Management: DataServer for Oracle).

See also 

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