| set_menu_item_property error in 12c - FRM41068 [message #668269] |
Thu, 15 February 2018 22:06  |
malu
Messages: 14
Registered: December 2017
|
Junior Member |
|
|
Hello ,
I need a help . we are doing forms migration from 11g to 12c.
But while the running the form set_menu_item_property in mmb file s giving error- FRM41068.
Any one please suggest what need to checked.
Thanks,
Malu
|
|
|
|
|
|
|
|
|
|
|
|
| Re: set_menu_item_property error in 12c - FRM41068 [message #668327 is a reply to message #668310] |
Sun, 18 February 2018 23:41  |
malu
Messages: 14
Registered: December 2017
|
Junior Member |
|
|
i tried synchronize . it is working .
but the problem is we are setting the menu labels inside loop;
so if i set synchronize before and after , it is giving performance issue.
NLS_LANG=AMERICAN_AMERICA.UTF8 - > this is already set
I think when we hard code the value , it is working ;
can anyone please tell why exactly this is happening .
|
|
|
|
|
|
|
|
| Re: set_menu_item_property error in 12c - FRM41068 [message #668340 is a reply to message #668338] |
Mon, 19 February 2018 03:02 |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
So badly?
Just to make things clear: this affects performance? I guess it shouldn't (though, I just hope it fixes the issue you have):
synchronize;
loop
...
set_menu_item_property ...
...
end loop;
synchronize;
Or did you use
loop
...
synchronize;
set_menu_item_property ...
synchronize;
...
end loop;
[Updated on: Mon, 19 February 2018 03:22] Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
| Re: set_menu_item_property error in 12c - FRM41068 [message #668715 is a reply to message #668703] |
Mon, 12 March 2018 07:22 |
iamorangehat
Messages: 3
Registered: August 2010
Location: Findlay, Ohio
|
Junior Member |
|
|
I was never able to get the synchronize to work, still got the error.
"Message" eliminated it but who the heck want to click on a message every time in the loop.
I was able to eliminate the error by throwing a dbms_output.put_line in front of the set_menu_item_property line.
Might be a stupid idea but it fixed the error.
dbms_output.disable;
<< then in my for x1 loop >>
dbms_output.put_line (x1.application_id || ' ' || x1.application_desc);
set_menu_item_property('SUB_MENU.SM' || ltrim(to_char(ctr,'09')), LABEL, x1.application_id || ' ' || x1.application_desc);
|
|
|
|
| Re: set_menu_item_property error in 12c - FRM41068 [message #668725 is a reply to message #668715] |
Mon, 12 March 2018 12:47 |
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
|
Senior Member |
|
|
iamorangehat wrote on Mon, 12 March 2018 08:22I was never able to get the synchronize to work, still got the error.
"Message" eliminated it but who the heck want to click on a message every time in the loop.
I was able to eliminate the error by throwing a dbms_output.put_line in front of the set_menu_item_property line.
Might be a stupid idea but it fixed the error.
dbms_output.disable;
<< then in my for x1 loop >>
dbms_output.put_line (x1.application_id || ' ' || x1.application_desc);
set_menu_item_property('SUB_MENU.SM' || ltrim(to_char(ctr,'09')), LABEL, x1.application_id || ' ' || x1.application_desc);
I am sorry, I do not believe you. DBMS_OUTPUT will not work in Forms, or more precisely, you cannot see any output from it.
[Updated on: Tue, 13 March 2018 14:03] Report message to a moderator |
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
