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!

frm-40106: No navigable items in destination block

704459Nov 19 2009 — edited Nov 19 2009
Hi,
I have a form with multiple tabs. In when_tab_page_changed trigger I have following code :
	IF some_condition and cur_tab = 'OPTIONS'  THEN
		create_parameter_duration_list;
	END IF;
the code in procedure create_parameter_duration_list is as follows
PROCEDURE create_parameter_duration_list IS
BEGIN
if get_block_property('report_request',status) <> 'NEW' then
       GO_BLOCK ('REPORT_REQUEST');   ---- Block is in TAB_1
       FIRST_RECORD;
       loop
           do_something.....
          IF :SYSTEM.LAST_RECORD = 'TRUE' THEN
	EXIT;
          ELSE
	NEXT_RECORD;
          END IF;
      END LOOP;
end if;

END;
The problem I am facing is, If a user enters some value in the report_request block (TAB_1) and goes to 'OPTIONS' tab , the form works fine....but if the user goes back to the tab_1 and clears the value in report _request block and then goes to OPTIONS tab then I get the frm-40106 error (No navigable items in destination block)
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 17 2009
Added on Nov 19 2009
9 comments
16,303 views