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.
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:
|
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:
|
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:
|
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.
|
origin_con_id |
character varying(256) |
Not supported. The value is 0. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot