Skip to Main Content

APEX

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!

Problem with APEX_APPLICATION.G_F02(i), ...

690818Apr 30 2009 — edited May 5 2009
Hello,

I'm encountering problems with my report. I have put an extra column with checkboxes into my report. The meaning of those checkboxes is to send a mail to all the employees that are checked. And this works. It sends me the right emails. But I put data into my email that comes from the report itself. I have also a column with a select list based on a lov with the language of the employee.

APEX_ITEM.SELECT_LIST_FROM_LOV(4,"TBL_WERKNEMERS"."LANGUAGEID",'lov_taalkeuze')"LANGUAGE"

In the report the language of the employee is automatically selected from the select list and this works also. (I need a select list so that the user can change the language if needed, otherwise I could get it from my database). But when I want do get my value to determine which language to use, it isn't always right. When I select every row it works. But when I check for example only the first and the fifth row, then the language of the first is correct, but for the fifth row it takes the value of the second row in my report (which wasn't checked).
This is how i call those values

FOR i in 1..APEX_APPLICATION.G_F01.COUNT LOOP
SELECT emailid into v_emailid FROM TBL_EMAIL where rapport = 'Test' and taalid = APEX_APPLICATION.G_F04(i);
END LOOP;

So I think the values in my APEX_APPLICATION.G_F01 are correct, because i get the right emails. But the values in APEX_APPLICATION.G_F02, APEX_APPLICATION.G_F03, APEX_APPLICATION.G_F04, ... aren't because I think all values are stored en when i loop through them the value according to the variable 'i' is returned.
Does anybody know how I can get the right value?

Any help would be greatly appreciated.

Bram.
This post has been answered by ATD on May 5 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 2 2009
Added on Apr 30 2009
19 comments
6,843 views