Re: Creating and calling stored procedure

#1

"Odd Bjørn Andersen" <obande (AT) online (DOT) no> a écrit dans le message de news: 462f446f$0$90269$14726298 (AT) news (DOT) sunsite.dk...

Quote:

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

http://download-uk.oracle.com/docs/c...5.htm#i1211948

Regards
Michel Cadot

#2

Odd Bjørn Andersen wrote:

Quote:

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

http://www.psoug.org
Click on Morgan's Library
Click on REF CURSOR
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Creating and calling stored procedure

comp.databases.oracle.tools comp.databases.oracle.tools

Re: Creating and calling stored procedure - 04-25-2007 , 10:36 AM

Re: Creating and calling stored procedure - 04-25-2007 , 03:51 PM