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

MY_SCHEDULER_PROGRAM_ARGS

MY_SCHEDULER_PROGRAM_ARG displays the parameters related to the programs owned by the current user. This view can be accessed by all users. Only the information about the current user can be viewed. This view exists in the PG_CATALOG and SYS schemas.

Table 1 MY_SCHEDULER_PROGRAM_ARGS columns

Name

Type

Description

program_name

character varying(128)

Name of the program to which the parameter belongs.

argument_name

character varying(128)

Parameter name.

argument_position

numeric

Position of the parameter in the parameter list.

argument_type

character varying(257)

Data type of a parameter.

metadata_attribute

character varying(19)

Not supported. Set it to NULL.

default_value

character varying(4000)

Default parameter value.

default_anydata_value

character varying(4000)

Not supported. Set it to NULL.

out_argument

character varying(5)

Reserved column. Set it to NULL.