Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: deterministic function
daud11_at_hotmail.com (Daud) wrote in message news:<f0bf3cc3.0211260110.4d10401f_at_posting.google.com>...
> Hi
>
> Is it possible to declare a function as DETERMINISTIC inside a package?
> I tried but got an error. Works fine in a standalone function.
> I searched this newgroups but did not find the answer. Anybody knows?
>
> rgds
> Daud
You have to declare it as deterministic in the package spec, but NOT in the package body.
I have this working fine on 9.2, what version are you working with?