Devart Forums

Posted: **Tue 03 Oct 2006 21:43**

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

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.

Posted: **Wed 04 Oct 2006 06:43**

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.