Database Reference
In-Depth Information
•
Post Installation Failure
: Shown after the application's supporting object
scripts have run, but only if errors were generated. The user can view the
errors that occurred.
•
Upgrade Welcome Message
: Provides a message informing the user that the
installer has detected preexisting supporting objects and that the Upgrade
Wizard will now be run.
•
Upgrade Confirmation Message
: Presents a message prior to running the
upgrade scripts to allow the user to choose whether to continue.
•
Upgrade Success Message
: Shown after the supporting objects upgrade
script is run successfully with no errors.
•
Upgrade Failure Message
: Shown after the supporting objects upgrade
script is run, but only if errors were generated. The user can view errors that
occurred.
•
Deinstallation Message
: Presented just prior to running the supporting ob-
jects deinstallation script.
•
Post-Deinstall message
: Presented just after running the supporting objects
deinstallation script.
Note
Because all script types are standard SQL and PL/SQL, you have the option of
writing quite complex logic that can decide within the script what steps to take.
However, there is no interactivity or shared session state between the individual scripts,
so you can't decide in the first script whether to run the second or third script. Every
script in the set will be run regardless of the result of the previous scripts. Errors are
shown only after all scripts have been run.
The process of building a packaged application that includes supporting objects can
be daunting. The good news is that, in a standard IT environment, the scripts to migrate
database objects are rarely processed using supporting objects. Although supporting
objects are very useful, they tend to lend themselves to situations, such as shrink-
wrapped software, where applications are sent to remote sites where there is little or no
direct interaction with the installing user.
For applications that are being developed and deployed in a single organization,
rules and guidelines are probably in place for migrating applications to production.
Make sure you check with your organization and adhere to those standards.
