Skip to Main Content

Java EE (Java Enterprise Edition) General Discussion

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!

Passing data to LOV groups at runtime

605207Oct 28 2007 — edited Oct 31 2007
Hello,

I am trying to create an LOV group that accepts variables during runtime in its WHERE clause. I created an entity group and a named bind variables. I have also created the changes at JHeadstart level using its editor. However, I am not sure how to pass a value from the UI to this named bind variable.
Here is what I am trying to do:
1. My LOV query looks like this;
SELECT LKC_LKT_TYPE, LKC_CODE, LKC_DESC
FROM LOOKUPS
WHERE LKC_LKT_TYPE = :LkcLktType
2. I have stored the LkcLktType (example GENDER_CD) in the tooltip of my group item. I want to pass this value to the LOV query named bind variable so that the LOV only displays codes relevant to the gender.

Any idea how I can do that? I feel I need to work on one of the generated Impl files but not sure.

Regards,
Amit
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 28 2007
Added on Oct 28 2007
3 comments
2,318 views