Re: PL/SQL Pragmas

Dave Macpherson <dmacpher_at_sas.ab.ca> wrote:
>This pragma is documented with the PL/SQL Addendum Manual for
>Oracle V7.1.4, and is not in the general PL/SQL 2.x manual.
>
>This pragma is required because you can now reference stored
>functions and packaged functions in a SELECT clause (and a
>WHERE, ORDER BY etc too!) and the database needs assurances
>about what the stored function is doing before it will allow
>you to reference it.

thanks dave - outstanding! another gem found hidden in the addendum.

one thing, i cannot get any FUNCTION that makes a call to TO_DATE compile with a PRAGRMA restrict_reference.

clues/comments?
//michael

-- 
:: michael ryan , ryan_at_xsoft.xerox.com
:: ob disclaimer: opinions expressed are not those of xerox, corp.