Re: Which PRAGMA to use? "Func. does not guarantee not to update db"

Simon Taylor wrote:

> ORA-06571: Function F_GET_SCCN_ID does not guarantee not to update database
>
> Which translates to:
>
> 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.
>
> (Interestingly, I don't get the error when I simply reference the function
> without the package name).
>
> My question is, does anyone know _which_ pragma I should use in my function.
> I can't find a similar example anywhere....

  PRAGMA RESTRICT_REFERENCES (F_GET_SCCN_ID, WNDS)   

---
Name   : Lun Wing San
Title  : Oracle Application Developer of Hong Kong Productivity Council
         Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841