Skip to Main Content

Java Development Tools

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!

Bind Variable Not Being Reset

702052Jul 26 2010 — edited Sep 8 2010
I am using JDeveloper 11.1.1.2 and ADF with BC. I have the following situation:

I have a view object whose where clause has multiple bind variables. On one of my pages, I dragged this view object as a form onto the page. I also dragged the ExecuteWithParams method for this view object onto my page as a command button. I dynamically set the bind variables for this action via EL-based NamedData elements. When I click the button, the query is run with the bind variables I specify. Everything looks great.

On another page, I am programmatically setting one of the bind variables (let's call it bv1) for the same view object and then navigating to the page described above. The data displays fine. However, when I try to use the command button (ExecuteWithParams) with a different value for bv1, the query continues to use the value that I set programmatically.

It seems like the bind variable value set programmatically (using vo.setNamedWhereClauseParam) always trumps the one that gets set using the NamedData element in ExecuteWithParams. Why doesn't this value get reset with the value from the NamedData element?

Thanks,
Brad
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 6 2010
Added on Jul 26 2010
3 comments
2,387 views