Pipelined functions

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
Posts: 3
Joined: Tue 03 Oct 2006 19:48

Pipelined functions

Post by 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: 2756
Joined: Mon 13 Mar 2006 07:43

Post by 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.

Post Reply