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 ...
Get Oracle and PL/SQL Recipes: A Problem-Solution Approach now with the O’Reilly learning platform.
O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.