Re: PLS-00231: function 'TO_DOLLAR_STR' may not be used in SQL
From: Andy Hardy <aph_at_ahardy.demon.co.uk>
Date: 2000/02/02
Message-ID: <nC8dkKAL7Cm4EwtJ_at_ahardy.demon.co.uk>#1/1
Date: 2000/02/02
Message-ID: <nC8dkKAL7Cm4EwtJ_at_ahardy.demon.co.uk>#1/1
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 ===============================================================Received on Wed Feb 02 2000 - 00:00:00 CET