Updated on 2024-05-07 GMT+08:00

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(64)

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, and is NULL for other data types.

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 customized 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.
  • Leave it empty for other types.

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.