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

VIEW: SYS.ALL_PROCEDURES

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

Functions/procedures/packages/types/triggers available to the user

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (128)
OBJECT_NAME VARCHAR2 (128)
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 (128)
Name of the owner of the implementation type (if any)
IMPLTYPENAME VARCHAR2 (128)
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
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
FROM SYS.ALL_PROCEDURES;

Dependencies

[top of page]

SYS.ALL_PROCEDURES references the following:

SchemaSYS
ViewINT$DBA_PROCEDURES
TableOBJAUTH$
SYS.ALL_PROCEDURES is referenced by following:

SchemaPUBLIC
SynonymALL_PROCEDURES
SchemaSYS
Package BodyDBMS_DBFS_CONTENT - show dependent code
Package BodyDBMS_DBFS_CONTENT_ADMIN - show dependent code
Package BodyDBMS_DBFS_SFS - show dependent code
Package BodyDBMS_DESCRIBE - show dependent code