Re: Return Value for a stored procedure

From: Rene Nyffenegger <rene.nyffenegger_at_gmx.ch>
Date: 23 Oct 2003 07:37:03 GMT
Message-ID: <bn80ev$ua9pv$2@ID-82536.news.uni-berlin.de>

> 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..

Create a function instead of a procedure. hth
Rene

-- 
  Rene Nyffenegger
  http://www.adp-gmbh.ch

Received on Thu Oct 23 2003 - 02:37:03 CDT

This message: [ Message body ]
Next message: Paul Dixon: "Re: How to assign a value to a variable"
Previous message: William Brasky: "Secure JDBC connection to Oracle 9i"
In reply to: Florian Marinoiu: "Return Value for a stored procedure"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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