| Create a simple wrapper function in Oracle that will call the store procedure and return the exit code of the procedure then you can call use a retrieve like  SELECT myFunction() FROM dual;  Hope this helps.  : Hello,  : I have an Oracle stored procedure that returns an : integer value of 0-3 depending on the input.
 : Is there a way for 24x7 to get that returned value?  : Thank You,  : John 
 
 |