What is PLSQL_CODE_TYPE?

What is PLSQL_CODE_TYPE?

Rating:

PLSQL_CODE_TYPE is a parameter that specifies the compilation mode for PL/SQL library units. The two values of this parameter are as follows:

• INTERPRETED: This value specifies that the library units will be compiled to PL/SQL byte code format and such modules are executed by the PL/SQL interpreter engine.
• NATIVE: PL/SQL library units (with the possible exception of top level anonymous PL/SQL blocks) will be compiled to native (machine) code. Such modules will be executed natively without incurring any interpreter overhead.

If its value is changed it has no effect on PL/SQL library units that have already been compiled.
If a PL/SQL library unit is compiled in NATIVE mode, then all the succeeding recompilations of that library unit will use NATIVE compilation.

The various properties of this parameter are given below:

• Parameter type - String
• Syntax - PLSQL_CODE_TYPE = {INTERPRETED/ NATIVE}
• Default value - INTERPRETED

Rating: