Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

Part Number B14237-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

PLSQL_COMPILER_FLAGS

Property Description
Parameter type String
Syntax PLSQL_COMPILER_FLAGS = { [ DEBUG | NON_DEBUG ] [ INTERPRETED | NATIVE ] }
Default value INTERPRETED, NON_DEBUG
Modifiable ALTER SESSION, ALTER SYSTEM

Note:

This parameter is deprecated in favor of the PLSQL_CODE_TYPE and PLSQL_DEBUG parameters. Oracle recommends that you use PLSQL_CODE_TYPE and PLSQL_DEBUG instead. PLSQL_COMPILER_FLAGS is retained for backward compatibility only.

PLSQL_COMPILER_FLAGS specifies a list of flags for the PL/SQL compiler as a comma-separated list of strings.

Values:

The following combinations of flags are invalid specifications for the PLSQL_COMPILER_FLAGS parameter:

When the value of this parameter is changed, it has no effect on PL/SQL library units that have already been compiled. The value of this parameter is stored persistently with the library unit. If a PL/SQL library unit is compiled native, all subsequent automatic recompilations of that library unit will use native compilation.