Xref: alice comp.databases.oracle:77173 comp.databases.oracle.misc:52352 Path: alice!news-feed.fnsi.net!netnews.com!newsfeed.icl.net!dispose.news.demon.net!demon!news.demon.co.uk!demon!ahardy.demon.co.uk!aph From: Andy Hardy Newsgroups: comp.databases.oracle.misc,comp.databases.oracle Subject: Re: PLS-00231: function 'TO_DOLLAR_STR' may not be used in SQL Date: Wed, 2 Feb 2000 13:19:07 +0000 Organization: England Message-ID: References: <38980CE1.744C2A5B@homeNOSPAM.com> X-Trace: news.demon.co.uk 949503772 nnrp-09:16605 NO-IDENT ahardy.demon.co.uk:158.152.45.183 X-Complaints-To: abuse@demon.net MIME-Version: 1.0 X-Newsreader: Turnpike (32) Version 4.01 Lines: 16 In article <38980CE1.744C2A5B@homeNOSPAM.com>, Ken Wilson 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 ===============================================================