Database Workbench includes a powerful Stored Procedure Debugger tool so you can test your stored procedures.
Available only for Borland InterBase and Firebird.
Source Code
The Stored Procedure debugger has the same layout as the object editors and supports syntax highlighting as well. It shows you your breakpoints, code items as has several debug windows.
It also has a seperate SQL Editor to test your procedure results while debugging - it runs in the same transaction.
Evaluate/Modify Dialog
The Debugger also includes a powerful Evaluate/Modify dialog where you can edit parameter or variable values, check the result of expressions or create watches. Watches will be updated after executing each line, providing you with a nice way to check the result of a certain expression after each possible change.
Other Features
Many more features are included, like disabled breakpoints, breakpoint pass counts, conditional breakpoints, disabled watches and much more...
The Stored Procedure debugger has the same layout as the object editors and supports syntax highlighting as well. It shows you your breakpoints, code items as has several debug windows.
The Debugger also includes a powerful Evaluate/Modify dialog where you can edit parameter or variable values, check the result of expressions or create watches. Watches will be updated after executing each line, providing you with a nice way to check the result of a certain expression after each possible change.