Oops. :) Sorry for misleading information. Sure if you declare a function as
deterministic in package specification, or declare an internal function as
deterministic in package body, this should work. Dunno why I decided this
is not possible - probably drank too little coffee today and didn't wake up
fully yet. :)
--
Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.
"FC" <flavio_at_tin.it> wrote in message news:PlKE9.57335$744.2105606_at_news1.tin.it...
>
> "Vladimir M. Zakharychev" <bob_at_dpsp-yes.com> wrote in message
> news:arvqm0$6i1$1_at_babylon.agtel.net...
> > Afaik, this is not possible and the error message you got probably
> > indicates the same.
> >
> > --
> > Vladimir Zakharychev (bob_at_dpsp-yes.com)
> http://www.dpsp-yes.com
> > Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet
> applications.
> > All opinions are mine and do not necessarily go in line with those of my
> employer.
> >
> >
> > "Daud" <daud11_at_hotmail.com> 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
> >
>
> Folks,
> I am not sure what you say is true.
> Certainly you cannot declare a function as deterministic inside the package
> BODY, but you can declare the function as deterministic in the package
> specification module. I did it several times. :-)
>
> I will excerpt the following paragraph from the Application Development
> Fundamentals manual:
> "This keyword (DETERMINISTIC) may be placed on a function defined in a
> CREATE FUNCTION statement, in a function's declaration in a CREATE PACKAGE
> statement, or on a method's declaration in a CREATE TYPE statement. It
> should not be repeated on the function's or method's body in a CREATE
> PACKAGE BODY or CREATE TYPE BODY statement."
>
> Bye,
> Flavio
>
>
Received on Tue Nov 26 2002 - 07:12:48 CST
