Oracle Debugger Beta

We finally finished implementing a debugger for Oracle in QweryBuilder. It was setup to work very similar to how the debuggers for Sybase ASE and SQL Anywhere work. In order to make sure we didn't miss anything important, we need people to beta test it for us. If you're interested in trying it out, you can download 7.3.0 Beta here:

http://www.werysoft.com/downloader.aspx?file=QweryBuilderSetup730.exe

Any issues or questions you have can be sent to support@werysoft.com.

Using the debugger should be straight forward. Here are a few things you should know before starting:

1. You can debug Packages, Procedures and Functions (Packages at the header level).
2. Before debugging an object, you have to compile it for debugging. You can do this by right clicking on the object in the Object Browser and selecting Compile for Debug.
3. Right click on an object in the Object Browser and select the Debug option.
4. A dialog will open that will allow you to input values for parameters. If you're debugging a Package, you need to select a Procedure or Function from the list.
5. Click the first toolbar button in this window to go to the debug window.
6. The first tab contains the SQL that will execute your object.
7. The second tab contains the syntax for your object.
8. You can set breakpoints in this second tab. You can also set breakpoints in objects that your procedure calls. Right click on an object and select Go To Definition to open it's code.
9. Click the Debug button to start.
10. Hover over a variable in the script editor to see it's current value.

Known limitations (i.e. things we are working on):

1. The Variables window doesn't show values for cursors or associative arrays.
2. Debugger doesn't step into anonymous block at the end of execution.

Please let us know what you think.

Thanks,

The Werysoft Team

www.werysoft.com