SYS.ALL_PLSQL_OBJECT_SETTINGS

The ALL_PLSQL_OBJECT_SETTINGS view displays information about the compiler settings for the stored objects accessible to the current user.

Related views

• SYS.DBA_PLSQL_OBJECT_SETTINGS displays information about the compiler settings for all stored objects in the database. It has the same columns as ALL_PLSQL_OBJECT_SETTINGS.

• SYS.USER_PLSQL_OBJECT_SETTINGS describes compiler settings for all stored objects that are owned by the current user. This view does not display the OWNER column.

Columns

Column name	Type	Description
OWNER	VARCHAR2(30) INLINE	Object owner
NAME	VARCHAR2(30) INLINE	Object name
TYPE	VARCHAR2(12) INLINE NOT NULL	Object type (such as PROCEDURE, FUNCTION)
PLSQL_OPTIMIZE_LEVEL	NUMBER	Optimize level used to compile the object
PLSQL_CODE_TYPE	VARCHAR2(4000) NOT INLINE	Compilation mode for the object
PLSQL_DEBUG	VARCHAR2(4000) NOT INLINE	Indication of whether the object was compiled with debug information
PLSQL_WARNINGS	VARCHAR2(4000) NOT INLINE	Compiler warning settings that were used to compile the object
NLS_LENGTH_SEMANTICS	VARCHAR2(4000) NOT INLINE	NLS length semantics that were used to compile the object
PLSQL_CCFLAGS	VARCHAR2(4000) NOT INLINE	Conditional compilation flag settings that were used to compile the object
PLSCOPE_SETTINGS	VARCHAR2(4000) NOT INLINE	Specification of whether the PL/SQL compiler generates cross-reference information