Oracle9i™ Development by Example

Using PL/SQL

The Oracle9iAS processes requests from users (Web browsers) and replies to these users with an HTML document. This document can be built either using a variety of methods, such as Java (see Chapter 10, “Using Java to Build Web Sites”), a CGI program, or using PL/SQL, as well as may other options.

The incoming URL has a virtual mapping to the PL/SQL cartridge in the Web server. Figure 8.9 in Chapter 8, “Building Web Sites with Oracle9i,” illustrates how the Web server knows to use the PL/SQL interface to process incoming requests from Web browsers. Listing 9.1 shows the simplest of PL/SQL Web sites, the classic “Hello World” message. Notice that this PL/SQL procedure is created in the normal manner with the CREATE OR REPLACE syntax. ...