28 PL/SQL Applications Using PSPs

PL/SQL developers can become Web developers quickly using PL/SQL Server Pages (PSPs). PSPs offer a productive way to author database-intensive Web pages and to leverage existing applications written in PL/SQL. PSPs are similar to JSPs in that they provide a powerful scripting environment and an easy way to separate page presentation from page logic. Oracle Application Server provides a compiler that translates the text of the PSP into a PL/SQL stored procedure, and stores it in the database for execution. The PL/SQL Web Toolkit (a component of Oracle Application Server) dynamically generates HTML from these stored procedures so they render in a Web browser.

Return to J2EE and Internet Applications

Return to Quick Tour Outline