Toad World® Forums

Unable to debug Stored Procedure and P/L Sql Packages in TOAD for DB2 5.0.3

Hi Everyone

I had Dowloaded TOAD for DB2 5.0.3 Trial and instatlled. I am unable to debug stored Procedure and P/L Sql Packages.

there is a option to degug stored Procedure but its not working for me.
i didnot find any option to debug P/L Sql Packages.

Please Help me out.

Ronjon
LEADS

Hi,
There are a lot of debug limitations from IBM,- and PL/SQL can’t be debugged even from IBM Data Studio,- look below.

http://pic.dhe.ibm.com/infocenter/ratdevz/v7r6/index.jsp?topic=/com.ibm.debug.spd.plsql.doc/topics/rbslimit.html

Debugging PL/SQL routines has these limitations:
• Debugging PL/SQL routines requires a connection using an Oracle Thin JDBC driver.
• You may debug a PL/SQL function only if it is in a PL/SQL package. You cannot debug any stand-alone function, regardless of its implementation language.
• You cannot update a LOB element (LOB variable, LOB field within a row variable, or LOB element within an array variable) while debugging.
• The debugger displays only the first 32 K bytes of a LOB value.
• The debugger does not support an array of row

Hi,
There are a lot of debug limitations from IBM,- and PL/SQL can’t be debugged even from IBM Data Studio,- look below.

http://pic.dhe.ibm.com/infocenter/ratdevz/v7r6/index.jsp?topic=/com.ibm.debug.spd.plsql.doc/topics/rbslimit.html

Debugging PL/SQL routines has these limitations:
• Debugging PL/SQL routines requires a connection using an Oracle Thin JDBC driver.
• You may debug a PL/SQL function only if it is in a PL/SQL package. You cannot debug any stand-alone function, regardless of its implementation language.
• You cannot update a LOB element (LOB variable, LOB field within a row variable, or LOB element within an array variable) while debugging.
• The debugger displays only the first 32 K bytes of a LOB value.
• The debugger does not support an array of row