Pipelined Function with Pipe Row() Pipes out 15 Rows at a Time (Doc ID 1265916.1)

Last updated on FEBRUARY 08, 2019

Applies to:

Symptoms

When called in SQL*Plus, using a pipelined function does not actually return the
values piped via pipe row() except in sets of 15 rows.

Here is an example scenario.
Create a table and sequence.  Then populate the table.

===DEFAULT OUTPUT===

COLUMN_VALUE
--------------------------------------------------------------------------------
1
2
3
4
5
6
7
8
9
10
11

COLUMN_VALUE
--------------------------------------------------------------------------------
12
13
14
15
--wait until issue ctrl-c  then
ERROR:
ORA-01013: user requested cancel of current operation
ORA-06512: at "USERX.A_PKG", line 12

15 rows selected.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.