Progress
DataServer
for ORACLE Guide


Retrieving Return Codes

An ORACLE stored procedure returns codes that provide information on its status. These codes indicate whether the stored procedure was successful, whether it found a missing object, whether it was in a deadlock, or whether it encountered an error condition. The following example of 4GL code runs the stored procedure pcust. It uses the PROC-STATUS function and the CLOSE STORED-PROC to retrieve the return code and assign the value to the variable stat:

/* Return status */

DEFINE VAR stat AS int.
RUN STORED-PROC pcust (PARAM num = ?, output PARAM orders = 0, output param 
states = 0).
CLOSE STORED-PROC pcust stat = PROC-STATUS.
IF stat = 0 then
DISPLAY pcust.orders pcust.states.
ELSE
DISPLAY stat. 

The ORACLE return codes have a range of values between -20000 and -20999. These values are user defined and you can test for them with the PROC-STATUS function.


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