SYS_PARAMETERS

Information on parameters of routines (procedures and UDFs)

Column name

Data type

Contents

SPECIFIC_SCHEMA

CHAR(31)

Name of the schema to which the
routine belongs

SPECIFIC_NAME

CHAR(31)

Specific name of the routine

ORDINAL_POSITION

SMALLINT

Sequence number of the parameter in
the routine

PARAMETER_MODE

VARCHAR(5)

IN	input parameter
OUT	output parameter
INOUT	input and output parameter

PARAMETER_NAME

CHAR(31)

Name of the parameter

DATA_TYPE

VARCHAR(24)

Data type of the column:
CHARACTER
CHARACTER VARYING
NATIONAL CHAR
NATIONAL CHAR VARYING
REAL
DOUBLE PRECISION
FLOAT
INTEGER
SMALLINT
NUMERIC
DECIMAL
DATE
TIME
TIMESTAMP

CHARACTER_
MAXIMUM_LENGTH

SMALLINT

Max. length of the column in code units

if data type is CHARACTER,
CHARACTER VARYING,
NATIONAL CHAR or NATIONAL
CHAR VARYING

NULL value in all other cases

NUMERIC_PRECISION

SMALLINT

Total number of significant digits

for numeric data types

NULL value in all other cases

NUMERIC_PRECISION_
RADIX

SMALLINT

Radix

for numeric data types

NULL value in all other cases

NUMERIC_SCALE

SMALLINT

Number of digits right of the dec. point

for exact numeric data types

NULL value in all other cases

DATETIME_PRECISION

SMALLINT

Number of digits right of the decimal
point

for the data types TIME and
TIMESTAMP

NULL value in all other cases

Table 119: SYS_PARAMETERS view of the SYS_INFO_SCHEMA (section 2 of 2)