DB_ARGUMENTS

DB_ARGUMENTS displays parameter information about stored procedures and functions accessible to the current user. This view exists in both PG_CATALOG and SYS schema. This view is accessible to all users and displays all information accessible to the current user.

**Table 1** DB_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)	Type of type_name: 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, and to NULL for other data types.
origin_con_id	character varying(256)	Not supported. Its value is 0.