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


TABLE: SYS.PROCEDUREINFO$

Object Details
Object Name: PROCEDUREINFO$
Object Type: TABLE
Owner: SYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Indexes
Index Type Uniqueness Tablespace Column
I_PROCEDUREINFO1 NORMAL UNIQUE TablespaceSYSTEM ColumnOBJ#
ColumnPROCEDURENAME
ColumnOVERLOAD#
Columns
Name Datatype Length Mandatory Comments
OBJ# NUMBER
Yes
PROCEDURE# NUMBER
Yes
OVERLOAD# NUMBER
Yes
PROCEDURENAME VARCHAR2 (128)
PROPERTIES NUMBER
Yes
ITYPEOBJ# NUMBER

SPARE1 NUMBER

SPARE2 NUMBER

SPARE3 NUMBER

SPARE4 NUMBER

Query Text

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


SELECT OBJ#
,      PROCEDURE#
,      OVERLOAD#
,      PROCEDURENAME
,      PROPERTIES
,      ITYPEOBJ#
,      SPARE1
,      SPARE2
,      SPARE3
,      SPARE4
FROM SYS.PROCEDUREINFO$;

Dependencies

[top of page]

SYS.PROCEDUREINFO$ does not reference any database object

SYS.PROCEDUREINFO$ is referenced by following:

SchemaSYS
ViewINT$DBA_PROCEDURES
ViewKU$_PROCINFO_VIEW