Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

APEX to Jasper parameter passing

Igor KortchnoïAug 2 2007 — edited Sep 1 2009
In my APEX application, I am calling Jasper PDF reports from javascript. On page 0, there are parameters necessary for the java program to connect to DB (jdbc driver class and connect string, without uid/pwd). These parameters are retrieved from DB on APEX application start and are later passed among other parameters to java servlet in URL.

Is it possible for java servlet on Jasper side to get variables on APEX side and if yes, how?

If not, what is the simplest way to do the following: when user clicks on a button in the calling APEX application, a PL/SQL procedure is called that inserts parameters into a DB table and returns a sequence number that is then passed by a javascript function to a java servlet (via URL) allowing it to fetch parameters? All this without submitting the page.

Igor
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 29 2009
Added on Aug 2 2007
16 comments
10,915 views