Updated on 2024-06-03 GMT+08:00

DB_ARGUMENTS

DB_ARGUMENTS displays parameter information about stored procedures and functions accessible to the current user. This view exists in the PG_CATALOG and SYS schemas. 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.

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. Its value is NULL.

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

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: The options are as follows:
  • 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 a data type.

type_name

character varying(128)

Parameter type name.

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.
  • NULL: The parameter is not of the table or view type.

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.

  • B: varchar, nvarchar2, bpchar, and char.
  • NULL: other types.

origin_con_id

character varying(256)

Not supported. The value is 0.