DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.ALL_PLSQL_OBJECT_SETTINGS

Object Details
Object Name: ALL_PLSQL_OBJECT_SETTINGS
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Compiler settings of stored objects accessible to the user

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (128) Yes Username of the owner of the object
NAME VARCHAR2 (128) Yes Name of the object
TYPE VARCHAR2 (12)
Type of the object: "PROCEDURE", "FUNCTION", "PACKAGE", "PACKAGE BODY", "TRIGGER", "TYPE", "TYPE BODY" or "LIBRARY"
PLSQL_OPTIMIZE_LEVEL NUMBER

The optimization level to use to compile the object
PLSQL_CODE_TYPE VARCHAR2 (4000)
The object codes are to be compiled natively or are interpreted
PLSQL_DEBUG VARCHAR2 (4000)
The object is to be compiled with debug information or not
PLSQL_WARNINGS VARCHAR2 (4000)
The compiler warning settings to use to compile the object
NLS_LENGTH_SEMANTICS VARCHAR2 (4000)
The NLS length semantics to use to compile the object
PLSQL_CCFLAGS VARCHAR2 (4000)
The conditional compilation flag settings to use to compile the object
PLSCOPE_SETTINGS VARCHAR2 (4000)
Settings for using PL/Scope
ORIGIN_CON_ID NUMBER

ID of Container where row originates
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT OWNER
,      NAME
,      TYPE
,      PLSQL_OPTIMIZE_LEVEL
,      PLSQL_CODE_TYPE
,      PLSQL_DEBUG
,      PLSQL_WARNINGS
,      NLS_LENGTH_SEMANTICS
,      PLSQL_CCFLAGS
,      PLSCOPE_SETTINGS
,      ORIGIN_CON_ID
FROM SYS.ALL_PLSQL_OBJECT_SETTINGS;

Dependencies

[top of page]

SYS.ALL_PLSQL_OBJECT_SETTINGS references the following:

SchemaSYS
ViewINT$DBA_PLSQL_OBJECT_SETTINGS
TableOBJAUTH$
SYS.ALL_PLSQL_OBJECT_SETTINGS is referenced by following:

SchemaPUBLIC
SynonymALL_PLSQL_OBJECT_SETTINGS