Skip Headers

Oracle® Database Reference
10g Release 1 (10.1)

Part Number B10755-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

ALL_ARGUMENTS

ALL_ARGUMENTS lists the arguments of the procedures and functions that are accessible to the current user.


Related View

USER_ARGUMENTS lists the arguments of the procedures and functions that are owned by the current user. This view does not display the OWNER column.

Column Datatype NULL Description
OWNER VARCHAR2(30) NOT NULL Owner of the object
OBJECT_NAME VARCHAR2(30)   Name of the procedure or function
PACKAGE_NAME VARCHAR2(30)   Name of the procedure or function
OBJECT_ID NUMBER NOT NULL Object number of the object
OVERLOAD VARCHAR2(40)   Overload unique identifier
ARGUMENT_NAME VARCHAR2(30)   Name of the argument
POSITION NUMBER NOT NULL Position in the argument list, or null for a function return value
SEQUENCE NUMBER NOT NULL Argument sequence, including all nesting levels
DATA_LEVEL NUMBER NOT NULL Nesting depth of the argument for composite types
DATA_TYPE VARCHAR2(30)   Datatype of the argument
DEFAULT_VALUE LONG   Reserved for future use
DEFAULT_LENGTH NUMBER   Reserved for future use
IN_OUT VARCHAR2(9)   Direction of the argument:
  • IN

  • OUT

  • IN/OUT

DATA_LENGTH NUMBER   Length of the column (in bytes)
DATA_PRECISION NUMBER   Length in decimal digits (NUMBER) or binary digits (FLOAT)
DATA_SCALE NUMBER   Digits to the right of the 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(30)   Owner of the type of the argument
TYPE_NAME VARCHAR2(30)   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.
TYPE_SUBNAME VARCHAR2(30)   Relevant only for package local types. Displays the name of the type declared in the package identified in the TYPE_NAME column.
TYPE_LINK VARCHAR2(128)   Relevant only for package local types when the package identified in the TYPE_NAME column is a remote package. This column displays the database link used to refer to the remote package.
PLS_TYPE VARCHAR2(30)   For numeric arguments, the name of the PL/SQL type of the argument. Null otherwise.
CHAR_LENGTH NUMBER
Character limit for string datatypes
CHAR_USED VARCHAR2(1)
Indicates whether the byte limit (B) or char limit (C) is official for the string


See Also:

"USER_ARGUMENTS"