Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Return Value for a stored procedure

Return Value for a stored procedure

From: Florian Marinoiu <x_at_x.com>
Date: Wed, 22 Oct 2003 19:55:18 -0400
Message-ID: <3F9718E6.D8C03D67@x.com>


Hi,

In MSSQL Server developement I used the return value of a stored procedure to test for different things.

Is it a similar mechanism in ORACLE 8.1

Let's say that in a procedure after the commit I do a RETURN 0 and if an error occurs in the exception section I do a RETURN -1..

Thanks,
Florian Received on Wed Oct 22 2003 - 18:55:18 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US