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.

Here is the video

Comments:

Hi Shay, This demo doesn't work for me.

Posted by Kuba on January 09, 2009 at 07:51 PM PST #

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

Posted by shay on January 12, 2009 at 03:27 AM PST #

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

Posted by Julcar on August 26, 2009 at 08:03 AM PDT #

Hello. Unfortunately, I can't find this demo. Could you provide new link? Thank you

Posted by Olga on August 23, 2010 at 08:36 PM PDT #

HI Olga, Seems the demo got lost in the latest OTN reorg. You can see the basic way to work with an ExecuteWithParams here: http://blogs.oracle.com/shay/2009/12/adf_query_with_parameters_and.html

Posted by shay.shmeltzer on August 24, 2010 at 12:55 AM PDT #

Audio is not clear

Posted by guest on August 30, 2011 at 07:36 AM PDT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

me
I'm a Director of Product Management for the Oracle Java Development Tools.
Follow me:
Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today