Geek Answers Handbook

Updating a Single Procedure in Oracle Package

Using Oracle 10g.

I am writing a script to apply the delta changes made in our development system to our stage system.

Is there a way to modify or insert a separate procedure inside a package without including the entire contents of the package in my script? I think the answer is no, but I wanted to be sure, because it would be pretty ugly to include all the contents of any modified packages when the changes were small.

+5
source share
3 answers

Sorry, but your gut instinct is correct. The unit of change is the PACKAGE BODY.

, . script ?

+4

, . , script, . "meta- script" SQL Plus:

@@package1.spc
@@package1.bdy
@@package2.bdy
+2

Faced the same problem. Just create a separate package for a procedure that changes frequently.

0
source

More articles:


All Articles