Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Restrict Pragma
continuing...
You use the pragma restict references as stated in order to guarantee that the function will on update the database (WNDS - Write No Database State, WNPS - Write No Package State). This avoids the error 'Function does not guarantee not to update database' when using the function in a select statement.
Regards,
David.