---

PIPE ROW Statement

The PIPE ROW statement, which can appear only in the body of a pipelined table function, returns a table row (but not control) to the invoker of the function. A pipelined table function is declared with the option "PIPELINED".

Topics:

• Syntax

• Semantics

• Examples

• Related Topics

Syntax

pipe_row_statement ::=

Description of the illustration pipe_row_statement.gif

Semantics

row

The row (table element) that the function returns to its invoker, represented by an expression whose type is that of the table element.

If the expression is a record variable, it must be explicitly declared with the data type of the table element. It cannot be declared with a data type that is only structurally identical to the element type. For example, if the element type has a name, then the record variable cannot be declared explicitly with %TYPE or %ROWTYPE or implicitly with %ROWTYPE in a cursor FOR LOOP statement.

Examples

• Example 12-28, "Creating and Invoking a Pipelined Table Function"

• Example 12-29, "Pipelined Table Function for Transformation"

• Example 12-30, "Function with Two Cursor Variable Parameters"

• Example 12-31, "Pipelined Table Function as Aggregate Function"

• Example 12-32, "Pipelined Table Function that Does Not Handle NO_DATA_NEEDED"

• Example 12-33, "Pipelined Table Function that Handles NO_DATA_NEEDED"

Related Topics

In this chapter:

• "Function Declaration and Definition"

In other chapters:

• "Creating Pipelined Table Functions"