Toad World® Forums

Output format from executing a function

While testing functions I often use the format 'select f_functionname(parm1, parm2, parm3) from dual; and ‘execute as function’. Then I have a choice of deciphering the output either in the ‘Output’ pane, without gridlines, as:

Cursor (Field1, Field2, Field3, etc.)

value1, value2, value3, value4, value5,…

OR, in the grid1 pane, which displays it as a grid, but with all data comma-delimited in a single cell. Not a big problem if you’re only looking at a few values, but if you have a big report with numerous different data types, it’s a headache.

Is there some setting I can change or another way to execute a function to get the output in the normal Data Grid format? My only other recourse so far has been to pull the sql out of the function and substitute actual values for all the parameters.