Re: PRAGMA RESTRICT_REFERENCES - standalone function

I believe that if the standalone function is using a package such as DBMS_SQL which is not 'safe', then you will be unable to use it within another function. This is because the 'unsafeness' propagates. I think this became effective in v8 but I'm not sure.

Regards, David.

michael_bialik_at_my-deja.com wrote:

> Hi.
>
> Stand alone function does not need such pragma.
> PL/SQL is able to check the function's code and to verify that it is
> not offensive.
> You need pragma only with packages, because Oracle does not have
> such info when looking at SPEC part of package.
>
> HTH. Michael.
>
> In article <383CD2EE.42E889BE_at_sympatico.ca>,
> paraf_at_sympatico.ca wrote:
> > Hi,
> >
> > I have problem: I would like to be able to use standalone function in
> > another function used in select statement. In order to do that, the
> > function has to be defined with PRAGMA RESTRICT_REFERENCES to mark
> that
> > it doesn't update anything. I found only examples/description how to
> do
> > that with functions in packagas.
> >
> > What about standalone functions?
> >
> > Thanks for any help,
> > Artur
> >
> >
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Nov 29 1999 - 01:55:17 CST