I need to print out all the triggers/procedures from an Oracle 9iForms. When I open an Oracle 9iform in the Oracle form builder, I click on FILE/CONVERT but cannot see the triggers/procedures. Please help!!!!

Hi,

>> Oracle 9iForms, How to print out all the triggers and procedures in an Oracle 9iForms

In the data dictionarry, you have the dba_objects view that has all stored procedure and trigger headers and you join that into the dba_surce view for the source code.

If you don;t want to write your own scripts, you can download them here:

http://www.dba-oracle.com/oracle_scripts.htm

These triggers and procedures are internal to the Forms binary, not anything to do with being stored in the database.

You can lose all of your code in this area doing an upgrade by directly compiling a 6i fmb into a 9i fmx. You need to open the 6i fmb in 9i Forms Builder, save the file, and then compile it. A direct compilation from 6i fmb to 9i fmx trashes the code.

Of course, you have source control and can simply check out a good/un-hosed version of the fmb, correct?