Toad World® Forums

Output results from a ref cursor


#1

Hello,

I am running the new 6.2.0.1317 vesion. Can you show me a way to output results from a ref cursor? I can execute a procedure with out parameters and I can see the values of the out parameters in the output window. However, results from a ref cursor cannot be seen. Is there a perference I can change? Thanks.

Vas Lakshman


#2

Hi Vas,

For complex types, the value won’t be printed out into the Output window. However, you can generate a stub, modify the code to print out the value.

Gwen


#3

Hi Gwen,

This feature used to work fine in 5.5 version. Please check out the 2 screen prints. The first one is from 5.5 version. The second one is from 6.2 build 1332.

Thanks
Vas Lakshman
output_55.bmp


#4

Hi Gwen,

This feature used to work fine in 5.5 version. Please check out the 2 screen prints. The first one is from 5.5 version. The second one is from 6.2 build 1332.

Thanks
Vas Lakshman


#5

Hi Vas,

I think the workflow is a bit different. When the execution console is brough up, it will show IN and IN/OUT parameter. If you then click run to execute, this window will be split in half and display OUT parameter.

Gwen