Using stored function in a SELECT
Date: 16 Dec 1994 20:04:00 GMT
Message-ID: <445362.94Dec16120401_at_aisserver1.llnl.gov>
I'm trying to use a stored function from a SELECT statement, a new feature
in 7.1.3, am getting the following error:
ERROR at line 1:
Which is described as:
06571, 00000, "Function %s does not guarantee not to update database"
ORA-06571: Function VAL_PER_SINGLE 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
Now the question is, what is the syntax of the pragma to let the db know this function is 'safe' ?
I've looked through all the manuals I can get a hold of and can find no reference to this new pragma.
Thanks in advance.
Grant Johnson Internet: grantj_at_llnl.gov
Lawrence Livermore National Lab PacBell Net: (510) 423-0406
Received on Fri Dec 16 1994 - 21:04:00 CET