The following table shows
-specific details for
some specific columns returned by getFunctionColumns.
Columns in the ResultSet returned by
getFunctionColumns
This table lists and describes -specific details for some columns in the ResultSet returned by the getFunctionColumns method.
Column
Description
COLUMN_TYPE
A short indicating what the row describes. Is always
DatabaseMetaData.functionColumnIn if it represents a parameter;
DatabaseMetaData.functionReturn if it represents a return value; and
DatabaseMetaData.functionColumnResult if it represents a column in a
table function.
TYPE_NAME
-specific
name for the type.
NULLABLE
Always returns DatabaseMetaData.functionNullable.
REMARKS
A String which describes the Java type of the method
parameter.
ORDINAL_POSITION
The ordinal position, starting from 1, for the input
and output parameters for the function.
METHOD_ID
A -specific
column.
PARAMETER_ID
A -specific
column.
The following table shows
-specific details for
some specific columns returned by getProcedureColumns.
Columns in the ResultSet returned by
getProcedureColumns
This table lists and describes -specific details for some columns in the ResultSet returned by the getProcedureColumns methods.
Column
Description
COLUMN_TYPE
A short indicating what the row describes. Is always
DatabaseMetaData.procedureColumnIn if the parameter is (possibly
implicitly) declared as an IN parameter;
DatabaseMetaData.procedureColumnInOut if the parameter is declared as an
INOUT parameter; and DatabaseMetaData.procedureColumnOut if the parameter
is declared as an OUT parameter.
TYPE_NAME
-specific
name for the type.
NULLABLE
Always returns DatabaseMetaData.procedureNullable.
REMARKS
A String which describes the Java type of the method
parameter.
ORDINAL_POSITION
The ordinal position, starting from 1, for the input
and output parameters for the procedure.
METHOD_ID
A -specific
column.
PARAMETER_ID
A -specific
column.