4
PL/SQL Server Pages Migration

This chapter explains the process of migrating from PL/SQL Server Pages version 8.1.6.1 to 8.1.7 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.

Contents

• Pre-migration

• Environment

• Configuration

• Application Logic

• Tools

Pre-migration

No pre-migration 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 "Loading the PL/SQL Server Page into the Database as a Stored Procedure" in Chapter 15, "Developing Web Applications with PL/SQL" of Oracle8i Application Developer's Guide - Fundamentals. This book is available 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.

There are new PL/SQL Gateway features that are available for all PL/SQL Server Pages. See Using the PL/SQL Gateway in the Oracle9i Application Server Documentation Library for more information about these features.

Tools

No tools migration tasks are necessary.