Re: Proc or function to return a table

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. Received on Fri Sep 01 2006 - 05:01:55 CDT