Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
- Posts: 3
- Joined: Tue 03 Oct 2006 19:48
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;
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
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.