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!

Clearing second block from first block when user selects different value from a LOV

HawkerHunterApr 27 2015 — edited May 5 2015

I am working on a form which has two data blocks - Header and Detail

The user selects a value from an LOV in the header block and click s a button to show its details.

Now after the details are already displayed for a value in the LOV, I want to clear the Detail block when the user selects another value from the LOV in the Header Block.

I tried to use 'WHEN-VALIDATE-ITEM-TRIGGER' as well as 'POST-CHANGE' trigger and used the following code in the trigger:

GO_BLOCK('DETAIL');

CLEAR_BLOCK;

But after using this when we choose any value from the LOV it gives a message - 'Illigal restricted procedure GO_BLOCK in POST_CHANGE trigger.

Can anyone please let me know how can I do this.

Regards

Hawker

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 2 2015
Added on Apr 27 2015
14 comments
4,496 views