eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: SYS.DBA_ARGUMENTS

Object Details

Object Name:	DBA_ARGUMENTS
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

All arguments for objects in the database

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
OWNER	VARCHAR2	(128)	Yes
OBJECT_NAME	VARCHAR2	(128)		Procedure or function name
PACKAGE_NAME	VARCHAR2	(128)		Package name
OBJECT_ID	NUMBER		Yes	Object number of the object
OVERLOAD	VARCHAR2	(40)		Overload unique identifier
SUBPROGRAM_ID	NUMBER			Unique sub-program Identifier
ARGUMENT_NAME	VARCHAR2	(128)		Argument name
POSITION	NUMBER		Yes	Position in argument list, or null for function return value
SEQUENCE	NUMBER		Yes	Argument sequence, including all nesting levels
DATA_LEVEL	NUMBER		Yes	Nesting depth of argument for composite types
DATA_TYPE	VARCHAR2	(30)		Datatype of the argument
DEFAULTED	VARCHAR2	(1)		Is the argument defaulted?
DEFAULT_VALUE	LONG	(0)		Default value for the argument
DEFAULT_LENGTH	NUMBER			Length of default value for the argument
IN_OUT	VARCHAR2	(9)		Argument direction (IN, OUT, or IN/OUT)
DATA_LENGTH	NUMBER			Length of the column in bytes
DATA_PRECISION	NUMBER			Length: decimal digits (NUMBER) or binary digits (FLOAT)
DATA_SCALE	NUMBER			Digits to right of decimal point in a number
RADIX	NUMBER			Argument radix for a number
CHARACTER_SET_NAME	VARCHAR2	(44)		Character set name for the argument
TYPE_OWNER	VARCHAR2	(128)		Owner name for the argument type in case of object types
TYPE_NAME	VARCHAR2	(128)		Object name for the argument type in case of object types
TYPE_SUBNAME	VARCHAR2	(128)		Subordinate object name for the argument type in case of object types
TYPE_LINK	VARCHAR2	(128)		Database link name for the argument type in case of object types
PLS_TYPE	VARCHAR2	(128)		PL/SQL type name for numeric arguments
CHAR_LENGTH	NUMBER			Character limit for string datatypes
CHAR_USED	VARCHAR2	(1)		Is the byte limit (B) or char limit (C) official for this string?
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
,      PACKAGE_NAME
,      OBJECT_ID
,      OVERLOAD
,      SUBPROGRAM_ID
,      ARGUMENT_NAME
,      POSITION
,      SEQUENCE
,      DATA_LEVEL
,      DATA_TYPE
,      DEFAULTED
,      DEFAULT_VALUE
,      DEFAULT_LENGTH
,      IN_OUT
,      DATA_LENGTH
,      DATA_PRECISION
,      DATA_SCALE
,      RADIX
,      CHARACTER_SET_NAME
,      TYPE_OWNER
,      TYPE_NAME
,      TYPE_SUBNAME
,      TYPE_LINK
,      PLS_TYPE
,      CHAR_LENGTH
,      CHAR_USED
,      ORIGIN_CON_ID
FROM SYS.DBA_ARGUMENTS;

Dependencies

[top of page]

SYS.DBA_ARGUMENTS references the following:

SYS: INT$DBA_ARGUMENTS

SYS.DBA_ARGUMENTS is referenced by following:

PUBLIC: DBA_ARGUMENTS
SYS: XS_DIAG_INT - show dependent code