Home » SQL & PL/SQL » SQL & PL/SQL » how to add new procedures to existing package
how to add new procedures to existing package [message #262203] Sat, 25 August 2007 01:33 Go to next message
raja_grk
Messages: 5
Registered: August 2007
Junior Member
Hi,
I have one package with 2 procedures.Now i want to add one more new procedure to that package.How can i add?

Thanks & Regards,
Raja
Re: how to add new procedures to existing package [message #262204 is a reply to message #262203] Sat, 25 August 2007 01:46 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Replace the old package with the new one.
A package is a whole, you can't add or remove one part, you have to recreate the whole package.

Regards
Michel
Re: how to add new procedures to existing package [message #262205 is a reply to message #262204] Sat, 25 August 2007 01:48 Go to previous message
raja_grk
Messages: 5
Registered: August 2007
Junior Member
Thanks
Previous Topic: Audit history of pl/sql code..
Next Topic: How to recompile package second time
Goto Forum:
  


Current Time: Fri Dec 09 13:31:32 CST 2016

Total time taken to generate the page: 0.07856 seconds