Home » SQL & PL/SQL » SQL & PL/SQL » How can I get multiple records from store procedure?
How can I get multiple records from store procedure? [message #36083] Fri, 02 November 2001 21:03 Go to next message
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!

----------------------------------------------------------------------
Re: How can I get multiple records from store procedure? [message #36095 is a reply to message #36083] Mon, 05 November 2001 03:48 Go to previous messageGo to next message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
use pl/sql tables or nested tables or varrays .

----------------------------------------------------------------------
Re: How can I get multiple records from store procedure? [message #36100 is a reply to message #36083] Mon, 05 November 2001 11:00 Go to previous messageGo to next message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
http://osi.oracle.com/~tkyte/ResultSets/index.html

----------------------------------------------------------------------
Re: How can I get multiple records from store procedure? [message #36601 is a reply to message #36083] Wed, 05 December 2001 23:46 Go to previous message
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

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


Current Time: Thu Mar 28 14:30:11 CDT 2024