Column Name | Data Type | Description |
procedure_name | char(256) | The name of the procedure |
procedure_owner | char(32) | The owner of the procedure |
rescol_name | char(256) | The name of the parameter/result column |
rescol_sequence | integer | Ordinal position of parameter or result column in procedure declaration |
rescol_datatype | char(32) | Datatype of parameter/result column |
rescol_datatype_code | smallint | Numeric representation of datatype |
rescol_length | integer | Length of parameter/result column |
rescol_scale | integer | The second number in a two-part user length specification; for type name (len1, len2) it is len2 |
rescol_nulls | char(1) | Y indicates this parameter is null |
rescol_param | char(1) | Y indicates this is a parameter N indicates this is a result column |
rescol_defaults | char(1) | Y indicates this parameter has a default value |
rescol_default_val | varchar(1501) | Default value used if default parameter provided |