Packages - newbie Q

From: Steve Corbett <stevec_at_fcs.wa.gov.au>
Date: 1997/08/18
Message-ID: <33F810FD.2E9B@fcs.wa.gov.au>#1/1

I had created some stand-alone procedures and functions - and they worked fine.
Trying to do the right thing I have put them in a Package. Created Package and Package Body okay - no errors. Valid Status.

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

okay, ORA-06571 says:
 oerr ora 06571
06571, 00000, "Function %s does not guarantee not to update database"
// *Cause: A plsql function that does not have a pragma asserting that
it
// does not write any database state is referenced in a sql statement.
// Such functions cannot be used in sql statements.
// *Action: Recreate the function and/or the functions it calls with the
pragma

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 Mon Aug 18 1997 - 00:00:00 CDT