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

oracle plsql oracleforms
dhinkle picture dhinkle · May 14, 2013 · Viewed 12k times · Source

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.

Answer

Jeffrey Kemp picture Jeffrey Kemp · May 15, 2013

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/

Related questions

Evaluation of PL/SQL boolean variables in Oracle Forms

Suppose I have a BOOLEAN variable within a PL/SQL block in an Oracle Form: DECLARE is_viewable BOOLEAN; BEGIN is_viewable := ...; IF NOT is_viewable THEN raise_my_error(); // pseudo-code END IF; END; After stepping through this code several …

Read More
Oracle Form FRM-40735: ON-ERROR trigger raised unhandled exception ORA-06502

I have a table trigger like below: CREATE OR REPLACE TRIGGER PAT_BUR_DOB_TRG BEFORE UPDATE OF DOB ON PAT REFERENCING OLD AS OLD NEW AS NEW FOR EACH ROW -- PL/SQL Block begin tgln_sys_error_pkg.…

Read More
GO_BLOCK in WHEN_VALIDATE Trigger

I'm working with oracle forms. I've a procedure I have to run whenever a specific field's value is modified. The procedure I have to execute contains a go_block instruction, which can't be used in the when_validate_item trigger. …

Read More