Oracle® Web Application Programming for PL/SQL® Developers

Unit 11.3. Passing Parameters without Submitting Forms

Forms are perhaps the most common way of sending data from one page to another on the Web. However, there are other ways that information is passed from one page to another. This section guides you through passing parameters in a URL, in PL/SQL itself, and within JavaScript.

Passing Parameters in PL/SQL Calls

In PL/SQL, parameters can be passed when a procedure or function is called. The procedure being called must have IN parameters that can receive the data. This holds true regardless of whether a PL/SQL procedure contains Web Toolkit functionality.

Suppose a procedure starts like this.

FOR EXAMPLE

 CREATE OR REPLACE PROCEDURE subway (p_line IN VARCHAR2, p_passengers IN NUMBER) AS… ...