2.46 ALL_ARGUMENTS
ALL_ARGUMENTS
lists the arguments of the functions and procedures that are accessible to the current user.
Note:
The following changes have been made to this view:
-
Starting with Oracle Database 12c release 1 (12.1.0.2), this view omits procedures with no arguments. Prior to Oracle Database 12c release 1 (12.1.0.2), a procedure with no arguments was presented as a single row in this view.
-
Starting with Oracle Database 18c, this view displays only one row for an argument that is a composite type. Prior to Oracle Database 18c, this view displayed multiple rows for composite types.
To obtain information about composite type arguments, use the value of the
TYPE_NAME
column in this view to query theALL_PLSQL_TYPES
,ALL_PLSQL_TYPE_ATTRS
, andALL_PLSQL_COLL_TYPES
views, which fully describe composite types.
See Oracle Database Upgrade Guide for more information about these changes.
Related Views
-
DBA_ARGUMENTS
lists the arguments of the functions and procedures that are available in the database. -
USER_ARGUMENTS
lists the arguments of the functions and procedures that are owned by the current user. This view does not display theOWNER
column.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Owner of the object |
|
|
|
Name of the procedure or function |
|
|
|
Name of the package |
|
|
|
Object number of the object |
|
|
|
Indicates the |
|
|
|
Unique subprogram identifier |
|
|
|
Name of the argument A null argument name is used to denote a function return. |
|
|
|
This column holds the position of this item in the argument list, or |
|
|
|
Defines the sequential order of the argument. Argument sequence starts from 1. Return type comes first, and each argument will follow. |
|
|
|
Nesting depth of the argument for composite types Note: Starting with Oracle Database 18c, the value of this columns is always |
|
|
|
Datatype of the argument |
|
|
|
Specifies whether or not the argument is defaulted |
|
|
|
Reserved for future use |
|
|
|
Reserved for future use |
|
|
|
Direction of the argument:
|
|
|
|
Length of the column (in bytes) |
|
|
|
Length in decimal digits ( |
|
|
|
Digits to the right of the decimal point in a number |
|
|
|
Argument radix for a number |
|
|
|
Character set name for the argument |
|
|
|
Owner of the type of the argument |
|
|
|
Name of the type of the argument. If the type is a package local type (that is, it is declared in a package specification), then this column displays the name of the package. |
|
|
|
Relevant only for package local types. Displays the name of the type declared in the package identified in the |
|
|
|
Relevant only for package local types when the package identified in the |
|
|
|
Displays the type of the type described by the
|
|
|
|
For numeric arguments, the name of the PL/SQL type of the argument. Null otherwise. |
|
|
|
Character limit for string datatypes |
|
|
|
Indicates whether the byte limit ( |
|
|
|
The ID of the container where the data originates. Possible values include:
|
Note:
To list the procedure names in a package, use the ALL_PROCEDURES
view.
See Also:
-
"ALL_PROCEDURES" for information about the functions and procedures that are accessible to the current user