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

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(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 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.
  • Set this column to NULL 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.