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

VIEW: SYS.CDB_PROCEDURES

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

Description of the dba functions/procedures/packages/types/triggers in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (30)
OBJECT_NAME VARCHAR2 (30)
Name of the object: top level function/procedure/package/type/trigger name
PROCEDURE_NAME VARCHAR2 (128)
Name of the package or type subprogram
OBJECT_ID NUMBER

Object number of the object
SUBPROGRAM_ID NUMBER

Unique sub-program identifier
OVERLOAD VARCHAR2 (40)
Overload unique identifier
OBJECT_TYPE VARCHAR2 (13)
The typename of the object
AGGREGATE VARCHAR2 (3)
Is it an aggregate function ?
PIPELINED VARCHAR2 (3)
Is it a pipelined table function ?
IMPLTYPEOWNER VARCHAR2 (30)
Name of the owner of the implementation type (if any)
IMPLTYPENAME VARCHAR2 (30)
Name of the implementation type (if any)
PARALLEL VARCHAR2 (3)
Is the procedure parallel enabled ?
INTERFACE VARCHAR2 (3)
DETERMINISTIC VARCHAR2 (3)
AUTHID VARCHAR2 (12)
ORIGIN_CON_ID NUMBER

ID of Container where row originates
CON_ID NUMBER

container id
Query Text

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


SELECT OWNER
,      OBJECT_NAME
,      PROCEDURE_NAME
,      OBJECT_ID
,      SUBPROGRAM_ID
,      OVERLOAD
,      OBJECT_TYPE
,      AGGREGATE
,      PIPELINED
,      IMPLTYPEOWNER
,      IMPLTYPENAME
,      PARALLEL
,      INTERFACE
,      DETERMINISTIC
,      AUTHID
,      ORIGIN_CON_ID
,      CON_ID
FROM SYS.CDB_PROCEDURES;

Dependencies

[top of page]

SYS.CDB_PROCEDURES does not reference any database object

SYS.CDB_PROCEDURES is referenced by following:

SchemaPUBLIC
SynonymCDB_PROCEDURES
SchemaSYS
Package BodyDBMS_ASH_INTERNAL - show dependent code