Need P/L SQL Package Debugging option

Toad for IBM DB2
1

Hello,

My management recently Decide to go with IBM DB2 LUW 9.7. so
that I am Looking for a Development Tool.

I have Downloaded TOAD for DB2 5.1.0.452 Beta Version
and found P/L SQL Package Debugging option are missing here.

Please Let me know is there any option to debug P/L SQL
Package. If not, then when you will add this.

**I Need Very Early Response from you. **

**
color:#0070C0’>Best Regrads**

**
color:#0070C0’> **

**
color:#0070C0’>Ronjon Kumar Ghosh**

color:gray’>Software Architect

color:gray’>Software Services Division

**
color:#FF6600’>LEADS**

href=“http://www.leads-bd.com/”>
color:blue’>www.leads-bd.com
font-family:“Verdana”,“sans-serif”;color:gray’>

color:gray’>

color:gray’>+880 1611 274551 Mobile

color:gray’>+880 2 955 2145 Phone

color:gray’>

color:#333333’>
src=“cid:image001.png@01CD23C8.DCE6B170”
alt=“cid:image001.png@01C9BE6F.FFD92D00”>
id=“Picture_x0020_2” src=“cid:image002.png@01CD23C8.DCE6B170”
alt=“cid:image004.png@01C9BE6F.FFD92D00”>
id=“Picture_x0020_3” src=“cid:image003.png@01CD23C8.DCE6B170”
alt=“cid:image005.png@01C9BE6F.FFD92D00”>

image001.png

image002.png

image003.png

2

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

3

Hello
I found another Limitation of TOAD for DB2. that is i cant execute a procedure which has sys_refcursor as output param.

Ronjon

4

hi titov

Recently IBM Data Studio Development team fixed P/L SQL Package Debugging Issue. also they fixed prcedure execution with cursor paramater as output.

Ronjon

5

Please, give me script for verification

6

hi titov

what kind of script u required?
recently from IBM i recieved a db2 9.7 fixpack 5 and data studio patch to debug p/l sql packages.

can u come online with GMAIL. i am online with ronjon.g@gmail.com ID.

Ronjon

7

Can you also mention version of IBM Data Studio where it is supported?
So we will be able to test it.

8

Hi Titov

I am using IBM Data Studio 3.1.1 with DB2 9.7 fix pack 5.

9

I created CR 99,262 to track this issue but it will be implemented for after 5.1

10

Hi

following two feature need to be included immediately:

  1. PL/SQL Package Debugging
  2. Procedure Run with cursor as output parameter.

Ronjon.

11

Hi Ronjon,

I have already included support for PL/SQL debugging into the requirements for our 5.5 release which is scheduled for Q4 this year.

We are currently in the release stage for 5.1 which should be available around June/July.

Following this release and once we start on the 5.5 beta program and get this feature implemented, you will be able to have an opportunity to try it out.

Thanks,

John

12

hi John

what abount issue # 2.

i found TOAD for DB2 5.1 unable to work with procedure which has cursor as output parameter.

Thanks

Ronjon

13

This has been addressed in 5.1. Please check the latest beta.

Thanks,

John