4
PL/SQL Server Pages Migration

This chapter explains the process of migrating from PL/SQL Server Pages in Oracle9i Application Server. Since PL/SQL Gateway serves PL/SQL Server Pages, you must complete the PL/SQL Gateway migration steps in Chapter 3, "PL/SQL Gateway Migration" before continuing with this chapter.

The migration topics for this component are:

• Premigration

• Environment

• Configuration

• Application Logic

• Tools

Premigration

No premigration tasks are necessary.

Environment

No environment migration tasks are necessary.

Configuration

No configuration migration tasks are necessary.

Application Logic

Installing the new OWA packages during the PL/SQL Gateway migration invalidates all of the PL/SQL stored procedures generated for your PL/SQL Server Pages. You must reload your PL/SQL Server Pages to the database.

See Also: "Loading the PL/SQL Server Page into the Database as a Stored Procedure" in Oracle8i Application Developer's Guide - Fundamentals in the Oracle Database Documentation Library

If you do not reload your PL/SQL Server Pages to the database, they will be automatically reloaded during the next request.

See Also: Using the PL/SQL Gateway in the Oracle9i Application Server Documentation Library for more information on new features available for PL/SQL Server Pages.

Tools

No tools migration tasks are necessary.