ALL_PLSQL_OBJECT_SETTINGS

Previous Next JavaScript must be enabled to correctly display this content

3.10 ALL_PLSQL_OBJECT_SETTINGS

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

Related Views

DBA_PLSQL_OBJECT_SETTINGS displays information about the compiler settings for all stored objects in the database.
USER_PLSQL_OBJECT_SETTINGS displays information about the compiler settings for the stored objects owned by the current user. This view does not display the OWNER column.

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the object
`NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the object
`TYPE`	`VARCHAR2(12)`		Type of the object: `PROCEDURE` `FUNCTION` `PACKAGE` `PACKAGE BODY` `TRIGGER` `TYPE` `TYPE BODY`
`PLSQL_OPTIMIZE_LEVEL`	`NUMBER`		Optimization level that was used to compile the object
`PLSQL_CODE_TYPE`	`VARCHAR2(4000)`		Compilation mode for the object
`PLSQL_DEBUG`	`VARCHAR2(4000)`		Indicates whether the object was compiled with debug information or not
`PLSQL_WARNINGS`	`VARCHAR2(4000)`		Compiler warning settings that were used to compile the object
`NLS_LENGTH_SEMANTICS`	`VARCHAR2(4000)`		NLS length semantics that were used to compile the object
`PLSQL_CCFLAGS`	`VARCHAR2(4000)`		Conditional compilation flag settings that were used to compile the object
`PLSCOPE_SETTINGS`	`VARCHAR2(4000)`		Settings for using PL/Scope
`ORIGIN_CON_ID`	`NUMBER`		The ID of the container where the data originates. Possible values include: `0`: This value is used for rows in non-CDBs. This value is not used for CDBs. n: This value is used for rows containing data that originate in the container with container ID n (n = 1 if the row originates in root)

See Also: