Pipelined functions

Pipelined functions

Postby ryanp » Tue 03 Oct 2006 21:43

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.
Posts: 3
Joined: Tue 03 Oct 2006 19:48

Postby Alexey » 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.
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Return to dotConnect for Oracle