OraFAQ Forum: SQL & PL/SQL » how to run packages procedure and function

Home » SQL & PL/SQL » SQL & PL/SQL » how to run packages procedure and function

Thu, 07 November 2002 05:56

Gurdeep Singh
Messages: 64
Registered: October 2002

Member

if i have package p1 having function f1 and procedure pp1. please tell me how can i run these function and procedure on sql prompt.

Thu, 07 November 2002 09:33

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

For functions, you can either:

sql>select p1.f1 from dual;

sql>var x number
sql>exec :x := p1.f1

For procedures:

sql>exec p1.pp1

Previous Topic:	Logon Trigger
Next Topic:	how to print sql table

Goto Forum:

]

Current Time: Mon Apr 29 06:44:23 CDT 2024