| My OracleGuide |
My Oracle Debug Guide ( MyODG ) |
PL/SQL is a server-side stored procedural language and is compiled and run within the Oracle Database.
Even if your PL/SQL code compiles successfully and runs it might not perform exactly as you want it to.
Packages like DBMS_OUTPUT, DBMS_PROFILER and UTL_FILE packages provide limited debugging capabilities.
Debgging the program manually can be problematic. More complex tasks can be accomplished using DBMS_DEBUG
It is possible to debug PL/SQL Code in Oracle with DBMS_DEBUG. But it is more complex to use without a GUI tool.
MyODG is a light weight debugging tool and provides database developers and DBAs with a
comprehensive environment for debugging PL/SQL program units.
The power of the tool is the ability to see and change variable values at runtime.
This is a prerequisite for any development environment. This can save development time
-- Set Break points at any line in the code during runtime
-- Walk through the code line by line
-- Step over a line
-- Step out of a child procedure
-- Go to next Break Point
-- Abort the running target program
-- Fetch variable values
-- Set values for variables
-- Run a query or DML statement
-- Debug packages, triggers and anonymous pl/sql code
Setup Instructions
1) Download the following jar files to a directory
classes12.jar
ojdbc14.jar
MyODG.jar
2) Open the command window and change to the above directory
3) Include path for Java Runtime Environment
Example : set path=C:\Program Files\Java\jdk1.6.0_17\bin
If you want to use a different Oracle JDBC driver then copy the jar files for oracle JDBC driver
4) Type the command
java -jar MyODG.jar
Send Your Comments to myoracleguide@gmail.com or