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!

show_view is not work in oracle forms

Andy CAug 19 2021

Hi Expert,
I would like to use the existing forms to call the new view but I add the condition "Show_View('View_name');" in the button trigger (WHEN-BUTTON-PRESSED). Then, no function can show the view. The below of my script detail:
-------------------------------------------------------------------------------------------------
Button (WHEN-BUTTON-PRESSED)
BEGIN
IF NOT FORM_SUCCESS THEN
raise FORM_TRIGGER_FAILURE;
end IF;

Show_View('CANVAS136');

EXCEPTION
when FORM_TRIGGER_FAILURE then
raise;
when OTHERS then
emessage(SQLERRM);
raise FORM_TRIGGER_FAILURE;
END;
------------------------------------------------------------------------------------------------

Thanks,
Andy

Image 68.jpg

Comments
Post Details
Added on Aug 19 2021
11 comments
2,827 views