PL/SQL Applications Using PSPs

PL/SQL developers can become Web developers quickly using Oracle PL/SQL Server Pages (Oracle PSP). Oracle PSP offer a productive way to author database-intensive Web pages and to leverage existing applications written in PL/SQL. Oracle PSP 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 Oracle 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.