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 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. |
package_name |
character varying(128) |
Package name. |
object_id |
oid |
OID of a function or stored procedure. |
overload |
character varying(40) |
The nth overloaded function of the same 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:
|
default_value |
text |
Not supported. The value is NULL. |
default_length |
numeric |
Not supported. The value is NULL. |
in_out |
character varying(9) |
Input and output attributes of a parameter:
|
data_length |
numeric |
Not supported. The value is NULL. |
data_precision |
numeric |
Not supported. The value is NULL. |
data_scale |
numeric |
Not supported. The 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. The value is NULL. |
type_owner |
character varying(128) |
Owner of the data type. |
type_name |
character varying(128) |
Parameter type name. Only the user-defined type is displayed. |
type_subname |
character varying(128) |
Not supported. The value is NULL. |
type_link |
character varying(128) |
Not supported. The value is NULL. |
type_object_type |
character varying(7) |
Type of type_name:
|
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. The value is NULL. |
char_used |
character varying(1) |
Not supported. The value is B for the varchar, nvarchar2, bpchar, or char type. The value is NULL for other data types. |
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