How do you search for PL/SQL code in Oracle forms fmb files?

Question

How do you find code if you don't know which Form it's in. If you know the form you can search pl sql but what if you don't know form?

For example I know the name of a field that is used in some code I want to see but don't know where code is at.

Solution 1

I highly recommend FormsTool - it understands the FMB, RDF and PLL formats natively, you can optionally search in object attributes as well as code. It shows the code search results with context (i.e. a few lines before and after).

http://www.orcl-toolbox.com/formstool/

Solution 2

I always use total commander for this, it is easy. You can find text in fmb's.

You can also open all your fmb's in one forms builder and then search over all of them. This is ofcourse no option if you got 1000 fmb's or so.

Third possibility is to convert your fmb's to xml and search in the xml files. http://docs.oracle.com/cd/E14373_01/migrate.32/e13368/appmgr_forms.htm#CHDCFFIC

Solution 3

I just use grep. There are versions for Windows, too.