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.