Reference Guide > TDV and Business Directory System Tables > ALL_PARAMETERS
 
ALL_PARAMETERS
The ALL_PARAMETERS system table exposes all the parameters that are used in published procedures to which the current user has access. Users can see procedures for which they have at least one privilege.
Column
TDV
JDBC Data Type
Nullable
Description
PARAMETER_ID
INTEGER
 
Identifier of the parameter. Primary key.
PARAMETER_NAME
VARCHAR(255)
 
Name of the parameter.
DATA_TYPE
VARCHAR(255)
 
String representation of the data type.
DIRECTION
SMALLINT
 
Value indicates the parameter type:
0—Unknown
1—IN
2—INOUT
3—RESULT
4—OUT
5—RETURN
ORDINAL_POSITION
INTEGER
Yes
Position of the parameter in relation to other parameters in the same procedure.
JDBC_DATA_TYPE
SMALLINT
 
JDBC/ODBC data types. For JDBC data types refer to: http://java.sun.com/j2se/1.4.2/docs/api/java/sql/Types.html.
PARAMETER_LENGTH
INTEGER
Yes
For a CHAR or VARCHAR parameter, the maximum length allowed; otherwise NULL.
PARAMETER_PRECISION
INTEGER
Yes
Value is the number of digits for DECIMAL or NUMERIC data types. If the data type is not DECIMAL or NUMERIC, it is NULL.
PARAMETER_SCALE
INTEGER
Yes
For a DECIMAL or NUMERIC data type, it is the number of digits. If the data type is not DECIMAL or NUMERIC, it is NULL.
PAREMETER_RADIX
INTEGER
Yes
Value is 10 for all numeric data types. For non-numeric data types, it is NULL.
NULLABLE
SMALLINT
 
Indicates whether the column is nullable:
0—NULL is not allowed.
1—NULL is allowed.
2—Unknown whether NULL is allowed or not.
IS_NULLABLE
VARCHAR(255)
 
Indicates whether the column is nullable:
YES—Column is nullable.
NO—Column is not nullable.
Blank string is returned if it is not known.
PROCEDURE_ID
INTEGER
 
Identifier of the procedure.
PROCEDURE_NAME
VARCHAR(255)
 
Name of the procedure.
SCHEMA_ID
INTEGER
Yes
Identifier of the schema.
SCHEMA_NAME
VARCHAR(255)
Yes
Name of the schema.
CATALOG_ID
INTEGER
Yes
Identifier of the catalog.
CATALOG_NAME
VARCHAR(255)
Yes
Name of the catalog.
DATASOURCE_ID
INTEGER
 
Identifier of the data source.
DATASOURCE_NAME
VARCHAR(255)
 
Name of the data source.
BD_DATASOURCE_
NAME
VARCHAR(255)
 
BD name of the data source.
ANNOTATION
VARCHAR(2147483647)
Yes
Annotation for the parameter.
OWNER_ID
INTEGER
 
Identifier of the person who created or owns the stored procedure in which the parameter is used.
OWNER
VARCHAR(255)
 
User name of the person who created or owns the procedure in which the parameter is used.
PARENT_PATH
VARCHAR(1043)
 
Path to the parent container.
BD_PARENT_PATH
VARCHAR(255)
 
BD path to the parent container.