PL/SQL Applications Using PSPs back | 1 2 3 4 5 6 7 8 9 10 | next
PL/SQL developers can quickly become Web developers 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. Oracle9iAS 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 Oracle9iAS) dynamically generates HTML from these stored procedures so they render in a Web browser.