Oracle and PL/SQL Recipes: A Problem-Solution Approach

14-4. Creating a Web–based Report Using PL/SQL Procedures

Problem

You need to generate a web page report that displays the results of a database query.

Solution

Create a package with two procedures, one to accept a user's input, and another to query the database and display the results. Suppose, for example, that you need a report that displays information for an employee whose employee ID has been entered by an authorized user. This recipe uses the employee table in the HR schema.

n

Note When defining packages that contain procedures you wish to access via web browsers, you must include each procedure you wish to access in the package specification. ...