Print Thread
Test window and CLOB
#36368 11/04/09 06:39 AM
Joined: Jul 2007
Posts: 28
R
Member
OP Offline
Member
R
Joined: Jul 2007
Posts: 28
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 => :pindata,
poutdata => :poutdata);
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?

Re: Test window and CLOB
Robertas #36369 11/04/09 07:39 AM
Joined: Jan 2003
Posts: 97
Denmark
B
Member
Offline
Member
B
Joined: Jan 2003
Posts: 97
Denmark
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?

Re: Test window and CLOB
Bo Pedersen #36370 11/04/09 08:18 AM
Joined: Jul 2007
Posts: 28
R
Member
OP Offline
Member
R
Joined: Jul 2007
Posts: 28
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?

Re: Test window and CLOB
Robertas #36371 11/04/09 08:45 AM
Joined: Jan 2003
Posts: 97
Denmark
B
Member
Offline
Member
B
Joined: Jan 2003
Posts: 97
Denmark
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.

Re: Test window and CLOB
Bo Pedersen #36387 11/04/09 02:07 PM
Joined: Jul 2007
Posts: 28
R
Member
OP Offline
Member
R
Joined: Jul 2007
Posts: 28
oh, thank you, I understood your first post wrongly


Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.102s Queries: 14 (0.054s) Memory: 2.5163 MB (Peak: 3.0430 MB) Data Comp: Off Server Time: 2024-05-18 19:14:57 UTC
Valid HTML 5 and Valid CSS