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

**URL:** <https://forums.toadworld.com/t/debug-pl-sql-for-pipeline-functions-definition-dialog-how-to/39724>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [July 20, 2017, 1:37am UTC](https://forums.toadworld.com/t/debug-pl-sql-for-pipeline-functions-definition-dialog-how-to/39724 "2017-07-20T01:37:58Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![damir.vadas\_250](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/damir.vadas_250/32/37_2.png) [@damir.vadas\_250](https://forums.toadworld.com/u/damir.vadas_250)\
**Post date:** [July 20, 2017, 1:37am UTC](https://forums.toadworld.com/t/debug-pl-sql-for-pipeline-functions-definition-dialog-how-to/39724/1 "2017-07-20T01:37:58Z")

</div>

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

 ![Pipeline_NO_OK.png](https://global.discourse-cdn.com/quest/original/2X/6/673f8861f97b06e1e24bd0cc8bec42bdce98e1c0.png)

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:

 ![Pipeline_OK.png](https://global.discourse-cdn.com/quest/original/2X/7/71875f69f79a4c58f637713990192a5e487bae75.png)

debug works.

Question:

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

---

<div class="post-metadata">

**Author:** ![mstaszew](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/mstaszew/32/23_2.png) [@mstaszew](https://forums.toadworld.com/u/mstaszew)\
**Post date:** [July 20, 2017, 6:29am UTC](https://forums.toadworld.com/t/debug-pl-sql-for-pipeline-functions-definition-dialog-how-to/39724/2 "2017-07-20T06:29:21Z")

</div>

What does the rest of your customized code look like?

Michael

---

<div class="post-metadata">

**Author:** ![damir.vadas\_250](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/damir.vadas_250/32/37_2.png) [@damir.vadas\_250](https://forums.toadworld.com/u/damir.vadas_250)\
**Post date:** [July 20, 2017, 7:15am UTC](https://forums.toadworld.com/t/debug-pl-sql-for-pipeline-functions-definition-dialog-how-to/39724/3 "2017-07-20T07:15:31Z")

</div>

… 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.