RE: function in sql

Hi Wolfgang,

as far as I know there is no such parameter. But I've read somewhere in oracle whitepapers that 8i doesn't require pragmas anymore, if the purity level was breaked you will get an error at runtime. I didn't check it yet.

Ed

>
>
> Hello,
> to use funktions in sql I would expect that I have to
> define a pragma restrict_reference.
>
> Some one told me that I have to set a init.ora-parameter
> to allow all functions to run in sql-statements
>
> Is this true ?
>
>
> Wolfgang Ludewig
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: wolfgang.ludewig_at_systor.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access /
> Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Tue Oct 31 2000 - 09:12:36 CST