OraFAQ Forum: Unix » how to call a package from Unix

Home » Infrastructure » Unix » how to call a package from Unix

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

how to call a package from Unix [message #118740]

Sat, 07 May 2005 11:22

Hina
Messages: 51
Registered: April 2004

Member

How to call a pl/sql package from unix ?

I can connect with the database using following command , but don't know how to call a stored package.

sqlplus -s scott/tiger

Thanks

Report message to a moderator

Re: how to call a package from Unix [message #118754 is a reply to message #118740]

Sat, 07 May 2005 20:22

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

exec package_name.procedure_name

Report message to a moderator

Re: how to call a package from Unix [message #118805 is a reply to message #118754]

Sun, 08 May 2005 21:25

Hina
Messages: 51
Registered: April 2004

Member

Thanks, but I am calling a function and I have to store a value returning from function.

In this case, how to apply 'exec' statement ?

Regards

Report message to a moderator

Previous Topic:	Calling function from Unix
Next Topic:	rm -f {} doubt

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Feb 19 16:41:07 CST 2025