O'Reilly logo

Oracle® Web Application Programming for PL/SQL® Developers by Benjamin Rosenzweig, Solomon Morse, Melanie Caffrey, Susan Boardman

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required