RE: function in sql

Pragma is just for packages. Format is pragma restrict_references(function, string, string,...)
like in "pragma restrict_references(myfunct, WNDS,WNPS)". The "myfunct" part has to be a part
of a package, otherwise, the pragma doesn't work. The only way to do so for the standalone
functions is to declare them to be "deterministic". That means exactly the same thing as the
pragma above and allows you to invoke the function so defined in a select list.
What is more, this particular pragma is being deprecated. The mighty and wise Oracle advises
us to use the new keyword or else....

-----Original Message-----
From: Tom Pall [mailto:tom_at_cdproc.com]
Sent: Tuesday, October 31, 2000 10:36 AM To: Multiple recipients of list ORACLE-L Subject: Re: function in sql

Correct, you need to define a pragma to restrict references for standalone functions.

The initialization parameter is for query rewrite, and is for function based indexes.
Two different things entirely.
----- Original Message -----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Tuesday, October 31, 2000 6:36 AM

> 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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Tom Pall
  INET: tom_at_cdproc.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