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

"Odd Bjrn Andersen" <oba@online.no> a crit dans le message de news: 462f446f$0$90269$14726@news.sunsite.dk...
|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/cd/B19306_01/server.102/b14357/ch5...

Regards
Michel Cadot

-----------------------------------------------Reply-----------------------------------------------