CLOB parameter nulled in test script

mor

Member
Hi,

I'm trying to test a procedure that receives a CLOB parameter. I am able to affect the CLOB with the ... button but when I execute the script my procedure receives a Null value in the CLOB. My other parameters of string type receive the values but not the CLOB.

I installed the latest version of PL/SQL developer (9.0.6.1665).

Thank you for your assistance!
 
Found the solution, changing the variable type to Temporary CLOB in my test script allowed me to get the value. When I view the value of the CLOB in the Script Test I get more than what I affected it with like open=F, temp=T, length=9, chunksize=4036, data=bidon but the right value is used to update my table.

Have a nice day!
 
Back
Top