Search notes:

Oracle PL/SQL: PRAGMA RESTRICT_REFERENCES

The pragma restrict_references allows to make sure that a function or procedure does not read or write from/to tables or modify package variables.
Typically, this pragma is used for functions, although it can be applied to procedures as well.
This pragma is deprecated in favor of using deterministic and parallel enabled functions.

Index