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!

Retrieving PL/SQL blocks of any .FMB program

26875Nov 8 2002
Hello friends at www.oracle.com ,

if we have many .FMB programs, and it's needed to search what program has - for example - an INSERT INTO (table) instruction, it's needed to investigate all procedures and triggers of each .FMB program. It creates a big problem: the need to open each .FMB program manually and search for it at each one.

Is it possible for me to retrieve all PL/SQL blocks - at triggers, or procedures - and look at these procedures with no need to open Forms program and open each .FMB module?

I'm supposing an environment where there's no documentation that relates the program and DML instruction(s) each program does. Besides, my goal is not to open Forms and search programs by using "Program/Find and Replace PL/SQL" at Forms menu, mainly because Forms does not open 2 or more programs at the same time when File/Open is used. Selecting two .FMB programs and opening them at Windows Explorer opens 2 copies of Forms, what's not desireable too.

I imagine it's possible to write an Unix shell or Windows batch that searches for the text at each .FMB program, but since .FMB is a binary file, it creates a problem for such way of searching.

Hope I was clear.

Thanks, and best regards,

--
Franklin Gongalves Jr.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 9 2002
Added on Nov 8 2002
3 comments
686 views