Possible Bug With Test Script

[kevb]

Hi

I wonder if you can help. I am using the test facility with in plsql dev, and taking advantage of setting the break points etc, which usually works very nicely.

However I am using the xml package to parse some xml. In this instance I am sending a very large xml string in to the function, the issue I am having is when I enter the string value next to the variable and hit start debugger, quite a lot of the string is being chopped off.

I can create my own script to send in the string ok, however when I run that I cant take advantage of the break points, which I really need.

Thanks

Kev

 

[Marco Kalter]

The Oracle Debug API only supports strings of up to 1000 bytes. If you need to see more, you will have to resort to dbms_output statements .

 

[kevb]

Hi

This is actually chopping of part of the string for the variable passed in rather than anything passed out.

 

[Marco Kalter]

I see. Maybe you need to declare the variable as "PL/SQL String" instead of plain "String", which is a SQL string that is limited to 4000 bytes. This can hold up to 32KB. Otherwise you would need a CLOB.