Unit 12.4. Developing PSPs

Whether you start with an existing stored procedure or an existing Web page, you see that with just a few changes and additions, you can create dynamic Web pages that perform database queries and other operations, and display the results from a Web browser. First things first, the file for a PL/SQL server page must have the extension .psp. Table 12.1 provides a summary for the four types of PSP Server Page elements.

PSP Directives

A PSP directive is simply a statement that provides the PSP compiler information about the page it is about to load into the database. Here is the syntax for a PSP directive:

<%@ directive attribute="value" [ attribute="value" ... ] %> 

Don’t forget the % inside the <, and just before ...

Get Oracle® Web Application Programming for PL/SQL® Developers now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.