Re: Creating and calling stored procedure

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Wed, 25 Apr 2007 17:36:27 +0200
Message-ID: <462f757b$0$11938$>

"Odd Bjørn Andersen" <> a écrit dans le message de news: 462f446f$0$90269$
|I am very new to Oracle and have a simple question, which I can't easy find
| an answer to in the documentation.
| I want to write a simple stored procedure in PL/SQL with one input
| parameter, and which returns 1 result set.
| That should be very simple, but I can't find any examples for this simple
| task in the documentation. Maybe
| I haven't looked in the right places :-) Is there anyone who could help me
| with an example?
| And I also want to call this procedure from SQL*Plus, like this: call (or
| execute) schema.proc (param=1) and get something like this in return:
| Id Name Address
| 1 AA Street 1, 12345 Town
| 2 BB Street 5, 12345 Town
| .....
| Is that possible? And what is the syntax? And what if there are out
| parameters, how do I specify them in the call (execute)
| statement?
| Regards
| Odd B Andersen

Michel Cadot Received on Wed Apr 25 2007 - 17:36:27 CEST

Original text of this message