---
title: "ProcedureParameters (SQL Server)"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/sqlserver/Database.Metadata.ProcedureParameters
original: https://documentation.invantive.eu/en/datamodels/sqlserver/Database.Metadata.ProcedureParameters
updated: 2026-11-18T23:25:40Z
license: https://documentation.invantive.eu/en/
---

# 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_LOCATOR` | `varchar2` | AS_LOCATOR | [ ] |  |  |
| `CHARACTER_MAXIMUM_LENGTH` | `int32` | CHARACTER_MAXIMUM_LENGTH | [ ] |  |  |
| `CHARACTER_OCTET_LENGTH` | `int32` | CHARACTER_OCTET_LENGTH | [ ] |  |  |
| `CHARACTER_SET_CATALOG` | `varchar2` | CHARACTER_SET_CATALOG | [ ] |  |  |
| `CHARACTER_SET_NAME` | `varchar2` | CHARACTER_SET_NAME | [ ] |  |  |
| `CHARACTER_SET_SCHEMA` | `varchar2` | CHARACTER_SET_SCHEMA | [ ] |  |  |
| `COLLATION_CATALOG` | `varchar2` | COLLATION_CATALOG | [ ] |  |  |
| `COLLATION_NAME` | `varchar2` | COLLATION_NAME | [ ] |  |  |
| `COLLATION_SCHEMA` | `varchar2` | COLLATION_SCHEMA | [ ] |  |  |
| `DATA_TYPE` | `varchar2` | DATA_TYPE | [ ] |  |  |
| `DATETIME_PRECISION` | `int16` | DATETIME_PRECISION | [ ] |  |  |
| `INTERVAL_PRECISION` | `int16` | INTERVAL_PRECISION | [ ] |  |  |
| `INTERVAL_TYPE` | `varchar2` | INTERVAL_TYPE | [ ] |  |  |
| `IS_RESULT` | `varchar2` | IS_RESULT | [ ] |  |  |
| `NUMERIC_PRECISION` | `byte` | NUMERIC_PRECISION | [ ] |  |  |
| `NUMERIC_PRECISION_RADIX` | `int16` | NUMERIC_PRECISION_RADIX | [ ] |  |  |
| `NUMERIC_SCALE` | `int32` | NUMERIC_SCALE | [ ] |  |  |
| `ORDINAL_POSITION` | `int32` | ORDINAL_POSITION | [ ] |  |  |
| `PARAMETER_MODE` | `varchar2` | PARAMETER_MODE | [ ] |  |  |
| `PARAMETER_NAME` | `varchar2` | PARAMETER_NAME | [ ] |  |  |
| `SPECIFIC_CATALOG` | `varchar2` | SPECIFIC_CATALOG | [ ] |  |  |
| `SPECIFIC_NAME` | `varchar2` | SPECIFIC_NAME | [ ] |  |  |
| `SPECIFIC_SCHEMA` | `varchar2` | SPECIFIC_SCHEMA | [ ] |  |  |

