Test window and CLOB

[Robertas]

Hello,
i have a package with procedure that takes CLOB as input parameter, when i try to test it (right click->test) i get a test window with code:

begin
-- Call the procedure
package_name.someprocedure(pindata => indata,
poutdata => outdata);
end;

i use Large data editor(in the bottom of test window) to set initial value of variable, but when i "step in" to procedure - input clob variable is empty!
Am i doing something incorrectly?

Also, is there a possibility to add a breakpoint in test window?

 

[Bo Pedersen]

Use Temporary CLOB for the input variable in order to be able to set the initial value.

And no, I don't think it is possible to set breakpoints in the test window. Perhaps a restriction with anonymous blocks?

 

[Robertas]

i know that i can set initial value using temporary clob, but would like to do this using Large data editor as well as i would like to see value of output parameter using Large data editor

can this be a bug?

 

[Bo Pedersen]

The bind variable shall be of the type Temporary CLOB instead of just CLOB. Then you can set the value using the Large data editor.

 

[Robertas]

oh, thank you, I understood your first post wrongly