Re: PL/SQL Package Functions in SELECT statement

The pragma that this error refers to is "RESTRICT_REFERENCES" and is found on page 2-5 of the PL/SQL Release 2.1 and Oracle Precompiliers Release 1.6 Addendum

This is out with Release 7.1.

The usage in the PL/SQL header is:

Function sumit(in_sum in number) return number; pragmarestrict_references(sumit,wnds,wnps,rnds,rnps);

where wnds="write no database state" and is required
      wnps="write no package state" and is not required
      rnds="reads no database state" and is not required
      rnps="reads no package state" and is not required

Hope this helps.

Alan Goodrich
agoodric_at_us.oracle.com Received on Fri Sep 08 1995 - 00:00:00 CEST