This illustration shows how the browser calls the PSP-stored procedure.
On the far left is a picture of a browser, with the caption "Browser calls PSP-stored procedure with URL. A double-headed arrow, labeled http://my_machine:7777/mypath/search_html
, connects the browser to a server, which is captioned "Web server maps URLs to PSP-stored procedure." A second double arrow runs between the web server and the database. The database contains two boxes, one labeled "PL/SQL Gateway" and the other labeled "PSP-stored Procedure," and is captioned "Database stores compiled PSP files as PL/SQL stored procedures." A table (search_table
) and an index (idx_search_table
) are also shown as part of the database.