Home » Developer & Programmer » Forms » Mass change Oracle Menu
icon1.gif  Mass change Oracle Menu [message #166297] Wed, 05 April 2006 10:33 Go to next message
atagore
Messages: 29
Registered: March 2006
Junior Member
Which Oracle internal SYSTEM or SYS owned table contains the text displayed by MENU EDITOR?
I see that ALL_SOURCE contains the PL/SQL ...

Report message to a moderator

Re: Mass change Oracle Menu [message #166399 is a reply to message #166297] Thu, 06 April 2006 02:55 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Menus are stored in 'mmb' files.

David

Report message to a moderator

Re: Mass change Oracle Menu [message #166467 is a reply to message #166297] Thu, 06 April 2006 08:07 Go to previous messageGo to next message
atagore
Messages: 29
Registered: March 2006
Junior Member
Yes.
I would like to know if there are Oracle internal tables -- such as ALL_SOURCE, TOOL_LTEXT, SRW2_MODULE, etc which contain menu related information.
Finding these table will allow mass change to entire menu system without editing each MMB file individually...

Report message to a moderator

Re: Mass change Oracle Menu [message #166539 is a reply to message #166467] Thu, 06 April 2006 20:24 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
No.

How many menus do you have? Normally the forms use the same menu.

David

Report message to a moderator

Re: Mass change Oracle Menu [message #166704 is a reply to message #166297] Fri, 07 April 2006 13:27 Go to previous messageGo to next message
atagore
Messages: 29
Registered: March 2006
Junior Member

Oracle Reports boilerplate, layout fields, etc are stored
in SRW2_MODULE and related tables.
Do you know which internal tables contain Forms/Menu items?

Report message to a moderator

Re: Mass change Oracle Menu [message #166869 is a reply to message #166704] Mon, 10 April 2006 01:49 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Google 'SRW2_MODULE' and you will find http://www.fors.com/orasupp/d2k/common/28449_1.HTM this refers to the tables used by Forms 4.5, Reports 2.5, and Graphics 2.5 for saving modules to the database.

David

Report message to a moderator

icon14.gif  Re: Mass change Oracle Menu [message #166968 is a reply to message #166297] Mon, 10 April 2006 10:31 Go to previous message
atagore
Messages: 29
Registered: March 2006
Junior Member

Thank you, Dave!

Report message to a moderator

Previous Topic: Problem in table updation
Next Topic: ORA-01422
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 07:36:28 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.