Re: Proc or function to return a table

On 1 Sep 2006 03:01:55 -0700, devjnr_at_gmail.com wrote:

>Sybrand Bakker ha scritto:
>
>> This is relevant, as your solution for sure is very inefficient (as
>> your need dynamic sql you force Oracle to parse every statement, and
>> parsing is a serialization device by design: as part of the shared
>> pool needs to be locked during parsing, other sessions can't access
>> that part of the shared pool).
>
>
>I found this situation "as is" and I cannot change the way are data
>represented and/or stored.
>
>I worked some years on databases ..but never seen it. Is this table
>representation through matrixes rare?
>
>> That all said, the best way to start would probably be to reconsider,
>> and read up on object types, and see what can be done at
>> http://asktom.oracle.com using object types.
>
>
>I'll read for sure about them.
>
>
>> Right now you need to convert your procedure to a *pipelined*
>> function, but be warned: your code is not going to scale at all.
>
>
>Can you give me a very simple example?
>
>D.

pipelined functions are documented in the PL/SQL reference manual. You can find this manual at http://tahiti.oracle.com in case you didn't already know.

--
Sybrand Bakker, Senior Oracle DBA