Return multiple values form Procedures

#1

Hi!
I'm a newbie in pl/sql programming..
my problem is how to return multiple values from a stored procedures..
I tryed with cursor but there's prob something i wrong..

Maybe u could post me an example of procedures returning a coloumn of values..
I'm becoming mad about this!! ^^
10x

#2

"kintaro" <aresi_michele (AT) yahoo (DOT) it> wrote

Quote:

Hi!
I'm a newbie in pl/sql programming..
my problem is how to return multiple values from a stored procedures..
I tryed with cursor but there's prob something i wrong..

Maybe u could post me an example of procedures returning a coloumn of
values..
I'm becoming mad about this!! ^^
10x

You would define multiple out parameters that are ref cursors. See
asktom.oracle.com and do a search.
Jim

#3

"Jim Kennedy" <kennedy-downwithspammersfamily (AT) attbi (DOT) net> wrote

Quote:

"kintaro" <aresi_michele (AT) yahoo (DOT) it> wrote in message
news:363e6471.0405250423.388295e5 (AT) posting (DOT) google.com...
Hi!
I'm a newbie in pl/sql programming..
my problem is how to return multiple values from a stored procedures..
I tryed with cursor but there's prob something i wrong..

Maybe u could post me an example of procedures returning a coloumn of
values..
I'm becoming mad about this!! ^^
10x

You would define multiple out parameters that are ref cursors. See
asktom.oracle.com and do a search.
Jim

I took a look at the site.. it seems good.. i hope to find out some
simple (very simple :P ) examples about my problems.. ^^

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

Return multiple values form Procedures

comp.database.oracle comp.database.oracle

Return multiple values form Procedures - 05-25-2004 , 07:23 AM

Re: Return multiple values form Procedures - 05-25-2004 , 07:28 AM

Re: Return multiple values form Procedures - 05-25-2004 , 12:33 PM