Hi,

> I am just curious are there any tools to debug
> stored procedures - inspect variables, set breakpoints etc etc etc...

Short answer: yes, there are.

Long answer: Firebird doesn't have any Stored Procedure debugging
facility, so real debugging of Stored Procedures isn't possible.

What, for example our tool, Database Workbench ( www.upscene.com )
does, is emulate the stored procedures at the client side while you're
setting "through" the procedure. You have the ability to set breakpoints,
inspect variables, change variable values and "trace into" other procedures.
This works quite well.

Give it a try, many people use it and are very happy with it.

--
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com