Progress
DataServer
for ORACLE Guide


PROC-STATUS Function

Returns the return status from an ORACLE stored procedure. The return status is an integer value that indicates whether a stored procedure failed and why it failed. See the ORACLE PL/SQL User’s Guide and Reference for descriptions of the possible values for the return status:

SYNTAX

PROC-STATUS 

EXAMPLE

This procedure runs the ORACLE stored procedure pcust and writes the results of the stored procedure into the proc-text-buffer. The CLOSE STORED-PROC statement then retrieves the output parameters. The return status is written to the variable stat and is displayed:

DEFINE VAR stat AS INTEGER.

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

SEE ALSO

CLOSE STORED-PROCEDURE Statement, PROC-HANDLE Function, RUN STORED-PROCEDURE Statement


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095