Menu
Using Oracle 10g.
I'm writing a script to apply the delta changes made on our development system to our stage system.
Is there a way to modify or insert an individual procedure within a package without including the entire package contents in my script? I think the answer is no, but I wanted to be sure because it's going to be pretty ugly to have to include the entire contents of any modified packages when the changes were small.
363
Because all objects in a package are stored as a unit, the ALTER PACKAGE statement recompiles all package objects. You cannot use the ALTER PROCEDURE statement or ALTER FUNCTION statement to recompile individually a procedure or function that is part of a package.
procedures in the body are private and can only be called from other modules inside the package.
Sorry but your gut instinct is correct. The unit of change is the PACKAGE BODY.
Not sure why you think it's ugly though. surely it's just a matter of calling a script for the package?
75
No, a package body must be replaced as a whole. Rather than include the code for several packages in a single script, I would create a file per package spec and a file per package body. You can then write a "meta-script" to run the required package changes in SQL Plus:
@@package1.spc
@@package1.bdy
@@package2.bdy
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
