Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ora817 sga problem
"Morff" <morff1_at_wp.pl> wrote in message
news:op.s1qqi9wrq0kutt_at_nt_januszk.domain_not_set.invalid...
> Dnia 13-12-2005 o 21:59:10 Sybrand Bakker <postbus_at_sybrandb.demon.nl>
> napisał:
>
>
>> Check the status of the function. Likely, for some reason it has gone
>> invalid. If so recompile the function.
>
> But the function is every time different :) and it is valid - I'm sure.
> I think database think's that user has not rights to execute this
> function.
>
>> The tric to flush the shared pool in such cases is .... ahem... quite
>> strange and disastrous.
>
> I know that , it helps .. but I dont want use it anymore - that's reason
> why I need your help :)
>
>
> --
> Pozdrawiam
> Morff
> ----------------------
> AQQ 141151
> Powered by Opera/M2
Are you perhaps dynamically creating/dropping tables on which the function depends ? Bad idea :-) Received on Tue Dec 13 2005 - 15:22:18 CST