ProcedureParameters: SQL Server
read only
- Catalog:
Database - Schema:
Metadata
Can only retrieve data.
Table Columns
The columns of the table ProcedureParameters are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
AS_ |
varchar2 |
AS_LOCATOR | |||
CHARACTER_ |
int32 |
CHARACTER_MAXIMUM_LENGTH | |||
CHARACTER_ |
int32 |
CHARACTER_OCTET_LENGTH | |||
CHARACTER_ |
varchar2 |
CHARACTER_SET_CATALOG | |||
CHARACTER_ |
varchar2 |
CHARACTER_SET_NAME | |||
CHARACTER_ |
varchar2 |
CHARACTER_SET_SCHEMA | |||
COLLATION_ |
varchar2 |
COLLATION_CATALOG | |||
COLLATION_ |
varchar2 |
COLLATION_NAME | |||
COLLATION_ |
varchar2 |
COLLATION_SCHEMA | |||
DATA_ |
varchar2 |
DATA_TYPE | |||
DATETIME_ |
int16 |
DATETIME_PRECISION | |||
INTERVAL_ |
int16 |
INTERVAL_PRECISION | |||
INTERVAL_ |
varchar2 |
INTERVAL_TYPE | |||
IS_ |
varchar2 |
IS_RESULT | |||
NUMERIC_ |
byte |
NUMERIC_PRECISION | |||
NUMERIC_ |
int16 |
NUMERIC_PRECISION_RADIX | |||
NUMERIC_ |
int32 |
NUMERIC_SCALE | |||
ORDINAL_ |
int32 |
ORDINAL_POSITION | |||
PARAMETER_ |
varchar2 |
PARAMETER_MODE | |||
PARAMETER_ |
varchar2 |
PARAMETER_NAME | |||
SPECIFIC_ |
varchar2 |
SPECIFIC_CATALOG | |||
SPECIFIC_ |
varchar2 |
SPECIFIC_NAME | |||
SPECIFIC_ |
varchar2 |
SPECIFIC_SCHEMA |