Home » Infrastructure » Unix » how to call a package from Unix
how to call a package from Unix [message #118740] Sat, 07 May 2005 11:22 Go to next message
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
Re: how to call a package from Unix [message #118754 is a reply to message #118740] Sat, 07 May 2005 20:22 Go to previous messageGo to next message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
exec package_name.procedure_name
Re: how to call a package from Unix [message #118805 is a reply to message #118754] Sun, 08 May 2005 21:25 Go to previous message
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
Previous Topic: Calling function from Unix
Next Topic: rm -f {} doubt
Goto Forum:
  


Current Time: Fri Mar 29 03:29:04 CDT 2024