|
|
Re: procedures [message #18674 is a reply to message #18671] |
Sun, 10 February 2002 20:59 |
Abdullah Gilani
Messages: 18 Registered: October 2001
|
Junior Member |
|
|
hi nash,
please follow,
======================
Execute of Procedure
======================
SQL> VARIABLE A REFCURSOR;
SQL> EXECUTE ASH4.GetServiceHist(:A,1);
PL/SQL procedure successfully completed.
SQL> PRINT :A
(Note: where ASH4 = Package Name
GetServiceHist = Procedure Name....that is Created in ASH4 Package
A = REFCURSOR....Out record set
1 = in value
PRINT :A = To View Out put on SQL Plus Screen)
=====================
Execute of FUNCTION
=====================
SQL> VARIABLE A REFCURSOR;
SQL> EXECUTE :A := ash3.ServiceReminders_ash(TO_DATE('08-NOV-00'),1);
PL/SQL procedure successfully completed.
SQL> PRINT :A;
Regards,
Abdullah Gilani
Email: syedgilani@hotmail.com
|
|
|