Toad World® Forums

How to alter the definition of the procedure to allow debugging?

I find the procedure and click the right mouse, then click “Debug”, but it popups the info as below:

Object does not allow debugging, please alter the definition of the procedure to allow debugging.

How to alter the definition of the procedure to allow debugging, thanks!

Toad DB2 supports debugging SQL procedures. To enable a DB2 LUW Procedure for debugging, right click on the procedure and select that action: “Compile SQL Procedure with Debug”.

Thanks Jeff, it’s a great help!