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.
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 ...