Pipelined functions

[ryanp]

How do I access the return value of a pipelined function defined inside a package as follows?

Code: Select all

create or replace package my_package is
  type my_type is table of some_table%rowtype;
  function my_function return my_type pipelined;
end my_package;

The code generated by the package wizard fails with the error: OCI-22303: type ""."MY_TYPE" not found.

[Alexey]

Pipelined functions can be called from "SELECT * FROM functionname" statements only.
Package wizard creates wrong code for such functions. We are going to investigate this.