Home » SQL & PL/SQL » SQL & PL/SQL » Recompilation of package
Recompilation of package [message #10104] Mon, 05 January 2004 20:00 Go to next message
resy
Messages: 86
Registered: December 2003
Member
hi,

Is it possible to recompile the package specification along with the body? or to recompile the specification without recompiling the body?

thanx in advance.
Re: Recompilation of package [message #10105 is a reply to message #10104] Mon, 05 January 2004 20:16 Go to previous messageGo to next message
CheekuK
Messages: 14
Registered: December 2003
Junior Member
Hi Raseena,
It is possible to recompile the package specification and the body together, and you can also recompile the specification alone but it has two outcomes:
1) if you change the package specification than your package body is rendered invalid and thus should be recompiled. If you have not made any changes to the signature of the method and have not added any new unit then your package body even if rendered invalid will not pose the problem because on calling it will be recompiled automatically.
2) If you make some changes in your package specification like adding a procedure or function or changing the signatures of the already existing procedure body will not be recompiled successfully and will throw and error.
So u shud always recompile the package body when you recompile the procedure. But vice-a- versa is not the cae. You can recompile package body without making Package specification invalid, because package body has a dependency on package specification but package specification does not have dependency on package body.
You can see the behaviour in user_dependencies.
Any doubts revert back.
Re: Recompilation of package [message #10106 is a reply to message #10105] Mon, 05 January 2004 20:53 Go to previous message
resy
Messages: 86
Registered: December 2003
Member
thanx a lot cheeku.
happy new year!
Previous Topic: HOW TO BINBIND VARIABLE IN FUNCTION
Next Topic: non functioning of set pause on command
Goto Forum:
  


Current Time: Tue Apr 23 13:06:39 CDT 2024