cursor as a parameter in Stored Procedure?? [message #36462] |
Thu, 29 November 2001 01:39 |
G Sreenivasulu Naidu
Messages: 1 Registered: November 2001
|
Junior Member |
|
|
Hi,
How to pass cursor as OUT parameter in the Stored procedure in Pl/SQL..i need this info urgently..
Pls send any information if u have regarding this ....
Thanks advance..
G Sreenivasulu Naidu
----------------------------------------------------------------------
|
|
|
|
Re: cursor as a parameter in Stored Procedure?? [message #36470 is a reply to message #36462] |
Thu, 29 November 2001 04:46 |
Suresh Vemulapalli
Messages: 624 Registered: August 2000
|
Senior Member |
|
|
step 1:
create ref cursor in package (global)
CREATE OR REPLACE PACKAGE sample IS
TYPE gen_cur IS REF CURSOR ;
END;
/
Step 2:
CREATE OR REPLACE PROCEDURE sample_proc(p_retcur OUT sample.gen_cur) IS
l_strquery varchar2(2000);
BEGIN
l_strquery := 'select * from tablename';
OPEN p_retcur FOR l_strquery;
end;
when you call above procedure, it will return output as resultset.
----------------------------------------------------------------------
|
|
|