Databases Reference
In-Depth Information
The following listing shows what that the generated ile will look like. The list of
package speciications and bodies are shortened for display purposes.
----------------------------------------------
-- Automatically created on: Sat 12-05-2012 --
----------------------------------------------
set define off
prompt ================================
prompt ==== Package Specificaties =====
prompt ================================
prompt Running docman_autorisatie_apex.pks
@@ docman_autorisatie_apex.pks
prompt Running docman_autorisatie_pkg.pks
@@ docman_autorisatie_pkg.pks
prompt Running docman_context_pkg.pks
@@ docman_context_pkg.pks
prompt =========================
prompt ==== Package Bodies =====
prompt =========================
prompt Running docman_autorisatie_apex.pkb
@@ docman_autorisatie_apex.pkb
prompt Running docman_autorisatie_pkg.pkb
@@ docman_autorisatie_pkg.pkb
prompt Running docman_context_pkg.pkb
@@ docman_context_pkg.pkb
set define '&'
We deliberately included
SET DEFINE OFF
at the beginning of the generated script,
to avoid being prompted for substitution variables when we run the script. Of
course, we also included
SET DEFINE '&'
at the end of the script to reset
SQL*Plus
.
Sometimes you will encounter
SET SCAN OFF
in
SQL*Plus
scripts. This will have the same effect as
SET DEFINE OFF
.
The former is the older version to achieve the same, hence we
prefer to use
SET DEFINE
.
Between each of the calls to run either the package speciication, or the package
body, we include a
prompt
command. This will help us when we run the
packages_all.sql
ile to install the package speciications and bodies. When a
package speciication or body does not compile properly, we get the information
that speciies the ile that was executed.