Shay Shmeltzer's Oracle Development Tools Tips

  • January 9, 2009

Setting Parameter for Before Page Loads

Shay Shmeltzer
Director of Product Management - Oracle

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.

Here is the video

Join the discussion

Comments ( 8 )
  • Kuba Saturday, January 10, 2009
    Hi Shay,
    This demo doesn't work for me.
  • shay Monday, January 12, 2009
    Kuba, thanks for letting me know - I fixed the problem now and the demo should be working.
  • Julcar Wednesday, August 26, 2009
    Hi, Shay
    When i submit the button (first example) got error: java.sql.SQLException: Missing IN or OUT parameter at index:: 1
  • Olga Tuesday, August 24, 2010
    Unfortunately, I can't find this demo. Could you provide new link?
    Thank you
  • shay.shmeltzer Tuesday, August 24, 2010
    HI Olga,
    Seems the demo got lost in the latest OTN reorg. You can see the basic way to work with an ExecuteWithParams here:
  • guest Tuesday, August 30, 2011

    Audio is not clear

  • Ashok Rajpurohit Wednesday, August 27, 2014

    Hi Shay,

    I don't see the video, can you provide the video link.

  • Shay Wednesday, August 27, 2014
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.