Retrieving PL/SQL blocks of any .FMB program
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.