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!

Oracle Forms error -frm-40105,frm-40738

user10991018Jan 22 2021

Hello,
i created a new tab page(added to existing tab pages) from forms builder
code is added to call the page in when tab page changed trigger and
in when newform instance to go to block and execute query.
but when trying to get into the new tab page runtime
i am getting error frm-40105 and frm-40738
my oracle version is
Oracle sql/plsql 11g
Forms/reports 11g.
my code is as follows.
when tab page changed
this form is earlier created using designer
and now adding manually after migrating from 10g to 11g

BEGIN
IF( :SYSTEM.TAB_NEW_PAGE IN ( 'CG$M_TAB_1_PAGE_1', 'PAGE511','CG$M_TAB_1_PAGE_2','PAGE551', 'CG$M_TAB_1_PAGE_3' ) ) THEN
CG$CIS0200_GLOBALS.ACTIVATE := TRUE;
CGLT$TAB_BLOCKS.CGLT$TAB_CHANGED;
END IF;
END;

when new form instance trigger
go_block('blockname');
execute_query;

can you please advise. images are uploaded.
img1.pngimg2.pngimg3.png
thanks.

Comments
Post Details
Added on Jan 22 2021
2 comments
511 views