getProcedureColumns()

Gets a description of a catalog's stored procedure parameters and result columns.

Only descriptions matching the schema, procedure and parameter name criteria are returned. They are ordered by PROCEDURE_SCHEM and PROCEDURE_NAME. Within this, the return value, if any, is first. Next are the parameter descriptions in call order. The column descriptions follow in column number order.

Each row in the ResultSet is a parameter description or column description with the following fields:

PROCEDURE_CAT	String	procedure catalog (may be null)
PROCEDURE_SCHEM	String	procedure schema (may be null)
PROCEDURE_NAME	String	procedure name
COLUMN_NAME	String	column/parameter name
COLUMN_TYPE	Short	kind of column/parameter: procedureColumnUnknown - nobody knows procedureColumnIn - IN parameter procedureColumnInOut - INOUT parameter procedureColumnOut - OUT parameter procedureColumnReturn - procedure return value procedureColumnResult - result column in ResultSet
DATA_TYPE	short	SQL type from java.sql.Types
TYPE_NAME	String	SQL type name, for a UDT type the type name is fully qualified
PRECISION	int	precision
LENGTH	int	length in bytes of data
SCALE	short	scale
RADIX	short	radix
NULLABLE	short	can it contain NULL? procedureNoNulls - does not allow NULL values procedureNullable - allows NULL values procedureNullableUnknown - nullability unknown
REMARKS	String	comment describing parameter/column

Note: Some databases may not return the column descriptions for a procedure. Additional columns beyond REMARKS can be defined by the database.

getProcedureColumns(string catalog,string schemaPattern, string procedureNamePattern,string columnNamePattern)

A catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria