Running and Debugging Oracle Forms 12C
Running and Debugging Oracle Forms 12C
While we develop an application in Oracle Form Builder and an error raise, we need to understand where it’s raised from.
There are several new features added in Oracle Form Builder12c, mostly, found in the main menu and toolbar. One of them is the Debug option which might come in handy. The option DEBUG is added in the main menu of Forms Builder:
How to proceed with DEBUG option
How can I proceed with this option? You are supposed to take the steps below:
- Specify the application URL in the Oracle Form Builder Preference
- Insert Break points in your module using Oracle Form
- Generate the execution file of your module and save it in required path.
- Run your application adding the debug parameter on WebLogic server.
- Take note of Host name and Port number while running your module.
- Attach Debug to your module by supplying the Host name and Port number in the Oracle Form Builder popup form.
And that is all. Now we look more deeply on the detail of these steps.
1. Debug Option - Runtime Preferences
You have your application specified in Runtime Preferences. Choose your preferences popup form through menu EDIT-> Preferences… Then add your application URL in Runtime Tab and click on OK.
2. Debug Option – Insert / Remove Breakpoints
Insert Break points in your module using Oracle Form Builder
How? In Oracle Form Builder on your development machine, open your module and right-click on your line number and click on Insert/Remove Breakpoint, where you want to start your debug process.
3. Debug Option – Execution Files & Path
Generate the execution file of your module and save it in required path.
4. Debug Option – URL & Parameters
Run your application adding the debug parameter on WebLogic server as:
- Name of the module must be declared: &form=customers_demo.fmx
- Debug parameter must set up to Yes: &debug=yes
5. Debug Option – URL & Parameters
Take note of Host name and Port number while running your module. Once you run your application, you have these popups with Host and Port parameters:
6. Debug Option – Attach Debug
At the same time, through the Oracle form builder, you click on "Attach Debug" option from Debug menu then, form builder opens this screen, and you have to define the same information provided by the previous popup in the Attach Debug to form.
Debug Option – Debug mode
Well, you move forward in your application toward the section in the module which you desire to validate the error. Debug process stops the module execution at the same line of the code, which contains the break points.
Now, Oracle form builder will let you debug your code line by line in your development machine to find the error while the application is running even in WebLogic server.
You can proceed step by step by using F7 or if you want to skip some parts of the code you can use the other options provided here for you.
Debug Option – Debug Stepping
How do I use the Debug Stepping?
Here is a detailed image illustrating each debug option and its effects:
Debug Option – Debug Console
In the debug console, you have a couple of useful windows which let you analyze more your information.
- Form values
- Watch window
- Global/System variables
- PL/SQL Packages
Debug Option – Stack window
The Stack window: In this window you may have a follow-up of the Stack Frames.
Debug Option – Form values
The Form Values window: You have all the values initiated in the items and Parameters of your form and once you step into the line of code which initiates these items and parameters you may find their new values as well.
Debug Option – Watch window
The Watch window: You may define your variable in watch window to follow the value which initiated inside while you move forward in the code.
Debug Option – Variables window
The Variables window: You have all the variables defined in your debug section and once you step into the line of code which initiates these variables you may find their new values as well.
Debug Option – PL/SQL Packages window
The PL/SQL Packages window: In this window you have a list of the PL/SQL Packages with their values.
Debug Option – Global/System Variables window
The Global/System Variables window: In this window you have a list of the Global or system variables.
Debug Option – Breakpoints window
The Breakpoints window: Also, you have a list of your breakpoints with the source code, plus the line number where you can modify them as well.