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!

Validation on APEX_ITEM with IR

MisterQApr 12 2011 — edited Apr 15 2011
Hello,

I had an interactive report with an apex_item.select_list so that the user can directly modify a column with a set of values.

Problem is that performance is not so good as it is doing a select for each record I guess.

So I have replaced it with an apex_item.text and added a validation to verify the correctness of new values. It's OK except that when a value is not correct I'm loosing all data that I have entered.

Any idea how to keep those data when validation returns "not ok"? Or how to optimze performance with apex_item.select_list ?

Thanks in advance,
Q
This post has been answered by jariola on Apr 14 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 13 2011
Added on Apr 12 2011
18 comments
426 views