PROC-STATUS function

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

PROC-STATUS

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.

OpenEdge Release 10.2B