Home » SQL & PL/SQL » SQL & PL/SQL » Private Procedure (Oracle9i)
Private Procedure [message #445574] Tue, 02 March 2010 11:39 Go to next message
ramesh55.sse
Messages: 262
Registered: December 2008
Location: Hyderabad
Senior Member
Hi all,

There is any way to call private procedure out side of the package.If it's possible please give me eaxmple.

Thanks in advance.
Re: Private Procedure [message #445575 is a reply to message #445574] Tue, 02 March 2010 11:40 Go to previous messageGo to next message
cookiemonster
Messages: 12321
Registered: September 2008
Location: Rainy Manchester
Senior Member
No. That's the whole point of private procedures.
Re: Private Procedure [message #445577 is a reply to message #445574] Tue, 02 March 2010 12:12 Go to previous messageGo to next message
Michel Cadot
Messages: 63818
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If a private procedure could be called from outside the package how private it would be? What could be the difference with a non-private one?

<rant>
If you are too lazy to read the documentation where it is clearly explained you have to replace it by some intelligence.
Curiously I often noticed that the smartest people are also those that read the documentation and the opposite is often true.
</rant>

Regards
Michel

[Updated on: Tue, 02 March 2010 12:20]

Report message to a moderator

Re: Private Procedure [message #445601 is a reply to message #445577] Tue, 02 March 2010 22:01 Go to previous messageGo to next message
delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City
Senior Member
./fa/449/0/

regards,
Delna
Re: Private Procedure [message #445603 is a reply to message #445577] Tue, 02 March 2010 22:32 Go to previous messageGo to next message
yurkoz
Messages: 26
Registered: September 2009
Location: bronx
Junior Member
try to create public procedure in the same package that calls your private procedure.
at least C++ working like this
Re: Private Procedure [message #445657 is a reply to message #445603] Wed, 03 March 2010 03:43 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Quote:
try to create public procedure in the same package that calls your private procedure.
at least C++ working like this


All you need to do in Pl/Sql is include the function/procedure definition in the package header, and it instantly becomes a public procedure.
Previous Topic: I wan to find the biggest age number
Next Topic: Query Help - String Manipulation
Goto Forum:
  


Current Time: Sat Oct 01 09:13:29 CDT 2016

Total time taken to generate the page: 0.12162 seconds