ansaurus

Question

Updating an individual procedure in an Oracle package

Answer 1

+2 A:

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?

APC 2010-02-04 17:13:15

Answer 2

+1 A:

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

Tony Andrews 2010-02-04 17:14:04

you could break this concept down even further and have a file per procedure in the package header and body. This way your "meta-script" can pull together the pieces it needs at build time but it makes change tracking easier in your source control system, especially for large procedures.

ninesided 2010-02-04 17:30:01

Do you mean breakdown the script of a package body into multiple files with each package body procedure in a separate file? Eek. Think I'd avoid that. Change tracking is easier in a single file with diffs.

Nick Pierpoint 2010-02-04 18:49:22

No, no, no, I didn't mean that! Each file contains one **complete** package spec or body.

Tony Andrews 2010-02-04 19:59:06

ansaurus

tags:

views:

answers:

Updating an individual procedure in an Oracle package

related questions