Can SQL Optimizer load from Oracle form modules (*.fmb) files? ie. can they extract the correct SQL statements?
SQL are stored as quoted strings in fmb files. So SQL Scanner will be limited to find only SQL in one command line. In most cases, the SQL are broken into multiple parts and constructed back to the full SQL during run time. As a result, SQL scanner will not work well in such scenario. We would suggest to run the application so that all SQL are executed and then use SQL Inspector to extract them from SQL Area. This will be easier to get all SQL from the fmb.