Skip to Main Content

Oracle Forms

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!

Go_Item function not available in a When-Validate-Item Trigger

sharpeFeb 23 2010 — edited Mar 11 2010
Hi. I'm finding I can't use the Go_Item function in a When-Validate-Item Trigger because it's a restricted trigger. Is there a common method for firing a trigger that I can use to validate an item (similar to the When-Validate-Item trigger) that is not restricted where I can use built-ins like Go_Item, Go_Block, etc.... I would use the Key-Next-Item trigger, but it doesn't fire when a user mouse clicks outside of the item I need to validate.

I need to fire a validation on an item which identifies if certain values have been entered. If I find certain values then I need to navigate to a 'Problems Log' block where the user can fill out a problem record. Upon leaving the 'Problems Log' block I then need to return to the previous block and let the user continue entering items. All this navigation seems to be restricted in the When-Validate-Item trigger.

Any help would be greatly appreciated.
This post has been answered by Zeeshan BaiG on Feb 23 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 8 2010
Added on Feb 23 2010
7 comments
2,552 views