You can see the executed queries and its bind values in the jdeveloper console or messages window. By default, this option is not available in jdeveloper.
To enable the debug console option in Jdev 9i
1. Right click on project and select project properties
2. Navigate Configurations -> Development -> runner
3. Add the following parameter in the java options
-Djbo.debugoutput=console
4. Select OK
5. Rebuild the project and run again to see the debug information in jdeveloper log window
This option would be very helpful in finding out what going on in the bc4j objects. Including LOV queries, poplist queries, VOs etc. Whenever the query is executed through the AM or procedure is called, the bind variable values and executed sql will be displayed in the jdeveloper message window.
No comments:
Post a Comment