OraFAQ Forum: SQL & PL/SQL » How can I get multiple records from store procedure?

Home » SQL & PL/SQL » SQL & PL/SQL » How can I get multiple records from store procedure?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How can I get multiple records from store procedure? [message #36083]

Fri, 02 November 2001 21:03

Alex
Messages: 190
Registered: August 1999

Senior Member

I want to get some records from oracle store procedure.
In SqlAnyWhere,can do this way:
create procedure test()
results( fname char(10),lname char(10))
begin
select fname,lname from cust;
end.
How do it in oracle store procedure?
Can anybody tell me how to do?
thx!

----------------------------------------------------------------------

Report message to a moderator

Re: How can I get multiple records from store procedure? [message #36095 is a reply to message #36083]

Mon, 05 November 2001 03:48

Suresh Vemulapalli
Messages: 624
Registered: August 2000

Senior Member

use pl/sql tables or nested tables or varrays .

----------------------------------------------------------------------

Report message to a moderator

Re: How can I get multiple records from store procedure? [message #36100 is a reply to message #36083]

Mon, 05 November 2001 11:00

andrew again
Messages: 2577
Registered: March 2000

Senior Member

http://osi.oracle.com/~tkyte/ResultSets/index.html

----------------------------------------------------------------------

Report message to a moderator

Re: How can I get multiple records from store procedure? [message #36601 is a reply to message #36083]

Wed, 05 December 2001 23:46

mohmed
Messages: 1
Registered: December 2001

Junior Member

how to insert, delet and update by store procedure on sql server & what referance need to use ADO with
sql server

----------------------------------------------------------------------

Report message to a moderator

Previous Topic:	datatype for time
Next Topic:	passing more than 2 parameters to an cursor

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 01 09:53:56 CDT 2026