# running pipelined function executes things inside it twice

**URL:** <https://forums.toadworld.com/t/running-pipelined-function-executes-things-inside-it-twice/38194>\
**Category:** Toad for Oracle - Beta\
**Created:** [August 16, 2016, 4:55am UTC](https://forums.toadworld.com/t/running-pipelined-function-executes-things-inside-it-twice/38194 "2016-08-16T04:55:26Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![paul.jorstad](https://avatars.discourse-cdn.com/v4/letter/p/839c29/32.png) [@paul.jorstad](https://forums.toadworld.com/u/paul.jorstad)\
**Post date:** [August 16, 2016, 4:55am UTC](https://forums.toadworld.com/t/running-pipelined-function-executes-things-inside-it-twice/38194/1 "2016-08-16T04:55:26Z")

</div>

Running Toad for Oracle 12.10.0.18 agains Oracle Database 11g Release 11.2.0.4.0 - 64bit Production (but I’ve tried a few databases)

Steps to reproduce:

CREATE OR REPLACE TYPE “INTEGER\_TABTYPE” AS TABLE OF INTEGER;

CREATE OR REPLACE FUNCTION pipe\_test  
RETURN integer\_tabtype  
PIPELINED  
IS  
BEGIN  
DBMS\_OUTPUT.put\_line (TO\_CHAR (SYSTIMESTAMP));  
PIPE ROW (1);  
RETURN;  
END;

select \* from table(pipe\_test)

returns TWO lines of

16.08.2016 13.47.15,332000000 +02:00  
16.08.2016 13.47.15,332000000 +02:00

I checked running the query in SQLPLUS without the same issue.

---

<div class="post-metadata">

**Author:** ![rjesse](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/rjesse/32/156_2.png) [@rjesse](https://forums.toadworld.com/u/rjesse)\
**Post date:** [August 16, 2016, 6:07am UTC](https://forums.toadworld.com/t/running-pipelined-function-executes-things-inside-it-twice/38194/2 "2016-08-16T06:07:06Z")

</div>

In SQL\*Plus, if you have done a “SET SERVEROUTPUT ON”, I would expect two lines as well. One from your SELECT and one from the DBMS\_OUTPUT.PUT\_LINE. Toad just turns the SERVEROUTPUT on for you…

Let us know!

Rich

---

<div class="post-metadata">

**Author:** ![rjesse](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/rjesse/32/156_2.png) [@rjesse](https://forums.toadworld.com/u/rjesse)\
**Post date:** [August 16, 2016, 6:12am UTC](https://forums.toadworld.com/t/running-pipelined-function-executes-things-inside-it-twice/38194/3 "2016-08-16T06:12:23Z")

</div>

And if I had actually tried out your example, I would have seen what you mean. The DBMS\_OUTPUT output is what’s duplicated…

NM…

---

<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:** [August 16, 2016, 9:07am UTC](https://forums.toadworld.com/t/running-pipelined-function-executes-things-inside-it-twice/38194/4 "2016-08-16T09:07:23Z")

</div>

Fixed in next beta.

---

<div class="post-metadata">

**Author:** ![paul.jorstad](https://avatars.discourse-cdn.com/v4/letter/p/839c29/32.png) [@paul.jorstad](https://forums.toadworld.com/u/paul.jorstad)\
**Post date:** [August 19, 2016, 12:48am UTC](https://forums.toadworld.com/t/running-pipelined-function-executes-things-inside-it-twice/38194/5 "2016-08-19T00:48:00Z")

</div>

Thanks 🙂