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
|