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!

When validate trigger fires for execute_query

User_KVV1COct 15 2018 — edited Oct 19 2018

Hi All,

Have a search form, i have a validation on one of the search field.

If i give a wrong search field and press do a execute query, the validation fires 2 time.

In the KEY-EXEQRY trigger of search block i have below code

go_block ('ccc_reschedule');

clear_block;

EXECUTE_QUERY;

Please help me with this. I should get only one message.

pastedImage_0.png

Regards,

Balaji

This post has been answered by User_KVV1C on Oct 19 2018
Jump to Answer
Comments
Post Details
Added on Oct 15 2018
7 comments
2,745 views