Oracle PRAGMA TYPES

Pragma compiler directives instructs compiler with certain information. It is Processed at compile time not at run time. The directive restricts member sub programs to query or modify database tables and packaged variables.


PRAGMA directive should be in declarative section of the PL-SQL block.
As of release 11.2 we have 5 PRAGMA directives:


1) PRAGMA AUTONOMOUS_TRANSACTION
2) PRAGMA SERIALLY_REUSABLE
3) PRAGMA RESTRICT_REFRENCES
4) PRAGMA EXCEPTION_INIT
5) PRAGMA INLINE