Toad World® Forums

Debug PL/SQL for pipeline functions definition dialog, how to

Hi,
Toad 12.11.0.95 x64.
I want to debug PL/SQL pipline function.
Initial screen looks like:

I know that highlighted part is not defined (and probably should be) but running as is out of the box, raise an error:
ORA-06550: line 1, column 10:
PLS-00653: aggregate/table functions are not allowed in PL/SQL scope

So when I change manually code like:

debug works.

Question:

How to setup initial (genuine dialog) without writing my code?
Brg
Damir

What does the rest of your customized code look like?

Michael

… from table( xxdv_show_space_for( var_p_owner, var_p_seg_name) ) loop
dbms_output.put_line(i.owner); --anything here …just to have open cursor
end loop;
end;

Pretty narrow test…just to have execute pipelined function.