Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: PLS-00231: function 'TO_DOLLAR_STR' may not be used in SQL

Re: PLS-00231: function 'TO_DOLLAR_STR' may not be used in SQL

From: Andy Hardy <aph_at_ahardy.demon.co.uk>
Date: Wed, 2 Feb 2000 13:19:07 +0000
Message-ID: <nC8dkKAL7Cm4EwtJ@ahardy.demon.co.uk>


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 - 07:19:07 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US