simple pl/sql function question ?

To all:
I wrote a simple pl/sql function to decode a location field(this function does  not access any table). When I tried to execute the function I got following  error message.

ora 06571 "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 functions it calls with the pragma.
What do I have to do to calls with the pragma ?

Thanks in advance.

Ted ChynI Received on Fri Oct 24 1997 - 00:00:00 CDT