william milbratz wrote:
> Hi,
>
> We have a complex stored procedure that runs slowly under large
> volumes of data.
>
<snip>
> Some more info:
> the procedure in question receives as one of its params a
> comma-delimited-list of "principal Ids". This list is usually very
> short (1-6 entries). The procedure parses the list and populates a
> 1field/1key temp table. The procedure then uses that table in a
> complicated query to return the records "which the user has access
> to".
>
<snip>
Is there any way to put the logic into a view, as far as determining who
has access to which ids (w/ case, decode, etc)?
...
By session, do you mean the life of that particular user's transaction?
If so, would a package be more useful in this situation, to pass those
values?
Received on Fri Feb 06 2004 - 10:41:32 CST
