« Declarative Extension building for JDeveloper with the extension.xml | Main | Preventing Queries When Page First Loads »

Setting Parameter for Before Page Loads

One of the things that the new ADF controller allows you to do is call out to methods as part of your page flow. This can be used for example to set some initial values for a page before it displays.
One such common scenario is when you have a page that has a query based on a parameter - and you want to set a value for this parameter before you invoke the page.

I created a short video that shows two ways of accomplishing this.
I'm using there a simple ADF BC view object with a query like:
select * from employees where salary > :p_sal
The p_sal is a bind variable that I want to set before I show the page that displays a table based on this query.
The first part of the video shows how I can do this the easy way with one page that uses the executeWithParams operation.
The second part of the video shows how the first page can be a non-ADF BC page - that then calls a method in the adf-config.xml flow to execute the executeWithParams - and then the show page is invoked.

You can watch the demo here.

Comments (3)

Kuba:

Hi Shay,

This demo doesn't work for me.

shay:

Kuba, thanks for letting me know - I fixed the problem now and the demo should be working.

Julcar:

Hi, Shay

When i submit the button (first example) got error: java.sql.SQLException: Missing IN or OUT parameter at index:: 1

Post a comment

(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)