Re: deterministic function

Well, I expect Oracle to cache the result(s) somewhere, I think you should try with some sort of loop or sleep time taking seconds or even minutes before returning the result, then, if it works as you say, the second time you call the function with the same arguments, the response time should be instantaneous.

Bye,
Flavio

"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:as39ea$491$1$830fa79f_at_news.demon.co.uk...
>
> Whilst we are on this topic - has anyone every
> managed to prove that a deterministic function
> actually DOES anything special for Oracle ?
>
> In principle, if Oracle can avoid calling the
> function because it has recently called it
> with the same input, it is supposed to re-use
> the output: but I've not yet managed to build
> an experiment where I can see this happening,
> even under 9.2
>
>
> --
> Regards
>
> Jonathan Lewis
> http://www.jlcomp.demon.co.uk
>
> Next Seminar dates:
> (see http://www.jlcomp.demon.co.uk/seminar.html )
>
> ____Denver_______December 2/4
> ____England______January 21/23
>
>
> The Co-operative Oracle Users' FAQ
> http://www.jlcomp.demon.co.uk/faq/ind_faq.html
>
>
>
>
>
> Daud wrote in message ...
> >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
> >
> >I got it. Only declare in package spec...not in package body like you
> guys said.
> >It works even though it is a bit odd.
> >
> >thanks
> >Daud
>
>
Received on Wed Nov 27 2002 - 14:36:30 CST