OraFAQ Forum: Forms » Mass change Oracle Menu

Home » Developer & Programmer » Forms » Mass change Oracle Menu

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Mass change Oracle Menu [message #166297]

Wed, 05 April 2006 10:33

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

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

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

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

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

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

Re: Mass change Oracle Menu [message #166968 is a reply to message #166297]

Mon, 10 April 2006 10:31

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 11:09:26 CST 2025