PLSQL-PRAGMAS

PRAGMAS

Pragmas are compiler directives. They serve as instructions to the PL/SQL compiler. The compiler will act on the pragma during the compilation of the block.

Syntax:

            PRGAMA instruction_to_compiler.

PL/SQL offers several pragmas:

Ø  AUTONOMOUS_TRANSACTION

Ø  EXCEPTION_INIT

Ø  RESTRICT_REFERENCES

SERIALLY_REUSABLE