Progress
Language Reference


PROC-STATUS Function

Interfaces
OS
SpeedScript
All
All
Yes

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 Progress-supplied buffer, proc-text-buffer. The CLOSE STORED-PROCEDURE statement then retrieves the output parameters. The return status is written to the variable stat and is displayed. The same code works for accessing a stored procedure from an ODBC-compliant data source.

DEFINE VAR stat AS INTEGER.

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

NOTES

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