viewing clobs in a test window

[jrw579]

I am trying to debug a procedure that has a clob parameter using the test windows. I can set the clob value the same as any other parameter - but as I walk through the code that parameter is null. Is this tool unable to process those fields? Or do I need to set something?

 

[Marco Kalter]

Did you declare the variable as "Temporary CLOB"? This is required if you want to pass an input value.

 

[jrw579]

I do not have it as a Temporary CLOB as I've never heard of that.

So I have to modify my procedure every time I want to walk through the code in the test window? I don't want the temporary clob code in my procedure for production because it runs fine then. It's only the test window that doesn't process it.

 

[Marco Kalter]

No, you need to declare the variable in the Test Window as a "Temporary CLOB" instead of a "CLOB". Your program code remains unchanged.

 

[jrw579]

THANK YOU!! Works perfectly.