Pragma - Restrict References - urgent help...

I am trying to execute a STORED function through a sql statement.

select pkg.get_name
from dual;

get_name is a function in pkg package.,

When I execute this Oracle gives me the following message

ORA-06571 function name does not guarantee not to update database

Inorder to avoid, we have to put PRAGMA RESTRICT REFERENCES (wnds),

Do you know the exact format of this statement?

If so, can you kindly drop me an email at vandana_at_pacific.net.sg

Thanks in advance

N.Prabhakar Received on Sat May 15 1999 - 11:04:43 CEST