Home » SQL & PL/SQL » SQL & PL/SQL » package passing values
package passing values [message #251094] Thu, 12 July 2007 06:58 Go to next message
subhadip.chanda
Messages: 64
Registered: May 2007
Member
Is it possible to pass any value inside a package?
Re: package passing values [message #251095 is a reply to message #251094] Thu, 12 July 2007 06:59 Go to previous messageGo to next message
pablolee
Messages: 2836
Registered: May 2007
Location: Scotland
Senior Member
please clarify what you mean / need to do. Think about how you would want someone to ask a question of you.
Re: package passing values [message #251096 is a reply to message #251094] Thu, 12 July 2007 07:02 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes.

Regards
Michel
Re: package passing values [message #251098 is a reply to message #251096] Thu, 12 July 2007 07:03 Go to previous messageGo to next message
pablolee
Messages: 2836
Registered: May 2007
Location: Scotland
Senior Member
Laughing
Re: package passing values [message #251102 is a reply to message #251096] Thu, 12 July 2007 07:08 Go to previous messageGo to next message
subhadip.chanda
Messages: 64
Registered: May 2007
Member
Then How can i do it? please explain with some specific example.
Re: package passing values [message #251108 is a reply to message #251102] Thu, 12 July 2007 07:14 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Then what is your problem? please explain with some specific example.

Regards
Michel
Re: package passing values [message #251111 is a reply to message #251108] Thu, 12 July 2007 07:19 Go to previous messageGo to next message
subhadip.chanda
Messages: 64
Registered: May 2007
Member
supose 'my_package' is a package..so can we execute it like

SQL:> exec my_package(my_parameter);

rather than

SQL:> exec my_package.my_function(my_parameter);

is this possible?
Re: package passing values [message #251112 is a reply to message #251094] Thu, 12 July 2007 07:21 Go to previous messageGo to next message
MarcL
Messages: 455
Registered: November 2006
Location: Connecticut, USA
Senior Member
What does executing a package mean ?

A package is a container for functions and procedures and not executable code.
Re: package passing values [message #251113 is a reply to message #251111] Thu, 12 July 2007 07:22 Go to previous message
pablolee
Messages: 2836
Registered: May 2007
Location: Scotland
Senior Member
What does this have to do with the original question? And in answer to the last question, No
Previous Topic: PLSQL Tables!!! A little Help Reqd
Next Topic: finding common rows
Goto Forum:
  


Current Time: Sat Dec 10 00:54:44 CST 2016

Total time taken to generate the page: 0.11360 seconds