Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: PLS-00231: function 'TO_DOLLAR_STR' may not be used in SQL
In article <38980CE1.744C2A5B_at_homeNOSPAM.com>, Ken Wilson
<ken.wilson_at_homeNOSPAM.com> writes
>I am getting the above message and cannot figure out what is wrong with
>the code that's generating it. The sql script is being run under SQL
>Plus 3.3
Oracle is complaining because it does not know what the side-effects of your function are.
You need to look at PRAGMA RESTRICT_REFERENCES and move your function into a package.
Andy
--
Andy Hardy. PGP key available on request