Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: refcursor for pipeline table function?
Richard Kuhler <noone_at_nowhere.com> wrote in message news:<J9AFa.80395$x67.3672926_at_twister.socal.rr.com>...
> The solution you showed has a major drawback in that
> you've duplicated the entire declaration of your object to make your
> record.
Nah... If you take a closer look you would notice that they, the object type and the record type, have different structures. There are 3 distinct data structures in that little example: the table record, the record in the refcursor and the SQL object type you use to pipe row out of the pipelined function. All of them can be different.
The example was only a test to see if your claim that using record with pipelined fucntion has problems. As it turns out, it does not, as far as I can see. The bug you filed with ORACLE has nothing to do with the record type at all. It has to do with using user defined type in SQL and PL/SQL.