ADM_ARGUMENTS

ADM_ARGUMENTS displays parameter information of all stored procedures and 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 the PG_CATALOG and SYS schemas.

**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.
object_id	oid	OID of a function or stored procedure.
overload	character varying(40)	nth overloaded function of the name.
subprogram_id	numeric	Not supported. The value is NULL.
argument_name	character varying(128)	Parameter name.
position	numeric	Position of a 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	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. The value is NULL.
default_length	numeric	Not supported. The 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. The value is NULL.
data_precision	numeric	Not supported. The value is NULL.
data_scale	numeric	Not supported. The 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. The value is NULL.
type_owner	character varying(128)	Owner of a data type.
type_name	character varying(128)	Parameter type name.
type_subname	character varying(128)	Not supported. The value is NULL.
type_link	character varying(128)	Not supported. The 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. The value is NULL.
char_used	character varying(1)	Not supported. B: varchar, nvarchar2, bpchar, and char. NULL: other types.
origin_con_id	character varying(256)	Not supported. The value is 0.