OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » procedures

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

procedures [message #18670]

Sun, 10 February 2002 18:39

krishna
Messages: 141
Registered: October 1998

Senior Member

How does one call a stored procedure?

Report message to a moderator

Re: procedures [message #18671 is a reply to message #18670]

Sun, 10 February 2002 18:43

nash
Messages: 10
Registered: February 2002

Junior Member

Try this :

Execute procedure_name ;

HTH

nash

Report message to a moderator

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

Report message to a moderator

Previous Topic:	duplicates help !!!!!!!!!!!!
Next Topic:	triggers

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 06:00:53 CDT 2024