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

14-3 Creating an Input Form

Problem

You require a web page that accepts and processes data entered by users. The data should be collected on the opening page and processed (stored in a table, used to update rows in a table, etc.) when the user clicks the Submit button.

Solution

Create a package using the Oracle PL/SQL Web Toolkit to display a data entry form and process the results. In this example a simple data entry form is created to collect employee information and send the user's input to a second procedure for processing.

Note See Recipe 14-2 for more information on the common package, which is used in this recipe.

CREATE OR REPLACE PACKAGE ...