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

VIEW: SYS.USER_PLSQL_OBJECT_SETTINGS

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

Compiler settings of stored objects owned by the user

[View Source]

Columns
Name Datatype Length Mandatory Comments
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 NAME
,      TYPE
,      PLSQL_OPTIMIZE_LEVEL
,      PLSQL_CODE_TYPE
,      PLSQL_DEBUG
,      PLSQL_WARNINGS
,      NLS_LENGTH_SEMANTICS
,      PLSQL_CCFLAGS
,      PLSCOPE_SETTINGS
,      ORIGIN_CON_ID
FROM SYS.USER_PLSQL_OBJECT_SETTINGS;

Dependencies

[top of page]

SYS.USER_PLSQL_OBJECT_SETTINGS references the following:

SchemaSYS
ViewINT$DBA_PLSQL_OBJECT_SETTINGS
SYS.USER_PLSQL_OBJECT_SETTINGS is referenced by following:

SchemaPUBLIC
SynonymUSER_PLSQL_OBJECT_SETTINGS