Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Packages - newbie Q
When you execute a function from within SQL the server does not know what else the function may be doing e.g. other updates to tables or package variables. This information (known as purity level) must be passed to the server in the form a RESTRICT_REFERENCES PRAGMA defined when the function was created.
e.g. PRAGMA RESTRICT_REFERENCES (function_name,WNDS,WNPS,RNDS,RNPS);
I have listed all the types above, but only WNDS is mandatory.
An example is given on page 7-48 of the 7.3 Server Application Developers Guide.
Note that this purity level does not work for DBMS_SQL constucts or OCI calls.
Ian Cary Received on Wed Aug 20 1997 - 00:00:00 CDT