StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p><strong>1) Other than a collection of everything does a package serve any other purpose?</strong></p> <p>Other than that, it reduces the need to recompile other procedures that are dependant on a specific procedure when the specific procedure is altered.</p> <p>Consider an (ordinary, not package wise) <code>procedure XYZ(a in number)</code> that is called by many other procedures. If this procedure is altered, all the other procedures need to be recompiled which might reduce the availablity of the system.</p> <p>On the other hand, if the procedure is declared in a <code>package</code> and defined in a <code>package body</code> and the procedure is changed in the body only, (almost) no recompiling takes place.</p> <p><strong>2) To deploy this package do you need to set up the deployment space to already have all of the views/materialized views/ and tables that the package called? If not I am assuming the package will fail to execute.</strong></p> <p>No, you can install a <code>package body</code> without the dependant views or tables in place. The state of the package body will then be <code>INVALID</code> and no functionality of the package body can be used.</p> <p><strong>3) Can you code the package to skip functions and procedures it fails to execute on without bombing out?</strong></p> <p>Not sure, what the question is exactly. If the state of the package body is INVALID, no code can be executed, hence no <em>"bombing out"</em> can happen. </p> <p>However, if the bombing out occurs for a logical reason (such as a division by zero for example) you can always resort to the <code>exception when others then</code> construct.</p> <p><strong>4) When taking a package that successfully compiled in one place to another place what other things should I be aware of?</strong></p> <p>Again, not sure what you mean here. Could you elaborate what <em>one place</em> is? A schema? An instance? An installation, a company....?</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload