ADM_ARGUMENTS

ADM_ARGUMENTS displays parameter information of all stored procedures or functions. By default, only the system administrator can access this view. Common users can access the view only after being authorized. This view exists in both PG_CATALOG and SYS schema.

**Table 1** ADM_ARGUMENTS columns
Name	Type	Description
owner	character varying(128)	Owner of a function or stored procedure.
object_name	character varying(128)	Name of a function or stored procedure.
package_name	character varying(128)	Package name.
object_id	oid	OID of a function or stored procedure.
overload	character varying(40)	nth overloaded function of the name.
subprogram_id	numeric	Location of a function or stored procedure in a package.
argument_name	character varying(128)	Parameter name.
position	numeric	Position of the parameter in the parameter list. The value is 0 for the return value of the function by default.
sequence	numeric	Sequence of a parameter, which starts from 1, with the return type before all parameters.
data_level	numeric	Nesting depth of parameters of the composite type. The value is fixed at 0 because only one line is displayed for each parameter.
data_type	character varying(30)	Data type of a parameter.
defaulted	character varying(1)	Specifies whether a parameter has a default value: Y: yes. N: no.
default_value	text	Not supported. Its value is NULL.
default_length	numeric	Not supported. Its value is NULL.
in_out	character varying(9)	Input and output attributes of a parameter: IN: input parameter. OUT: output parameter. IN_OUT: input and output parameters. VARIADIC: VARIADIC parameter.
data_length	numeric	Not supported. Its value is NULL.
data_precision	numeric	Not supported. Its value is NULL.
data_scale	numeric	Not supported. Its value is NULL.
radix	numeric	Radix of a number, which is 10 when the data type is smallint, integer, bigint, numeric, or float. For other data types, set this column to NULL.
character_set_name	character varying(44)	Not supported. Its value is NULL.
type_owner	character varying(128)	Owner of the data type.
type_name	character varying(128)	Parameter type name. Only the user-defined type is displayed.
type_subname	character varying(128)	Not supported. Its value is NULL.
type_link	character varying(128)	Not supported. Its value is NULL.
type_object_type	character varying(7)	Types of types of the type_owner, type_name, and type_subname columns: TABLE: The parameter is of the table type. VIEW: The parameter is of the view type. For other data types, the value is NULL.
pls_type	character varying(128)	Name of the PL/SQL type for parameters of the number type. Otherwise, this column is empty.
char_length	numeric	Not supported. Its value is NULL.
char_used	character varying(1)	Not supported. Set it to B if the data type is varchar, nvarchar2, bpchar, or char. For other data types, set it to NULL.
origin_con_id	character varying(256)	Not supported. Its value is 0.