O'Reilly logo

Oracle and PL/SQL Recipes: A Problem-Solution Approach by Matt Arena, Josh Juneau

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

16-3. Accessing PL/SQL Web Procedures with HTTP

Problem

You are developing a Java web application that uses an Oracle Database. You have already created a PL/SQL web application that displays some particular data from your database that is generated from an input identifier. You want to use the PL/SQL web application to display that data by passing the necessary input from the Java web application.

Solution

Write your PL/SQL web program to accept parameter values within a URL. Pass the values from your Java web application to the PL/SQL application by embedding them within the URL that calls it. When the URL is clicked, then it will redirect control to the PL/SQL application, passing the parameters that are required to display the correct data. ...

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