Re: Packages - newbie Q

From: Steve Corbett <stevec_at_fcs.wa.gov.au>
Date: 1997/08/21
Message-ID: <33FBB31F.546D@fcs.wa.gov.au>#1/1

Thanks to all who responded to my query.

It seems that even though we are running V7.1.6 we need to use PRAGMA RESTRICT_REFERENCES, which is not documented until v7.3 - so i was working in the dark a bit, but what's new?

stevec.

Steve Corbett wrote:
> But when i run the function from Sqlplus I get:
>
> select surname, pk_phonetic.fn_phonetic(surname) from table;
> *
> ERROR at line 1:
> ORA-06571: Function FN_PHONETIC does not guarantee not to update
> database
>
> I have read PL/Sql user Guide Chapter 7 and Application Developer Guide
> Chapter 7 but am none the wiser.
> Where do i find out about this PRAGMA stuff.

-- 
Steve Corbett.       Perth  Australia  .       
stevec_at_fcs.wa.gov.au
scorbett_at_perth.dialix.oz.au

Received on Thu Aug 21 1997 - 00:00:00 CDT