|
Gets a description of the stored procedures available in a catalog. Only procedure descriptions matching the schema and procedure name criteria are returned. They are ordered by PROCEDURE_SCHEM, and PROCEDURE_NAME.
Each procedure description has the the following columns:
PROCEDURE_CAT
|
String
|
procedure catalog (may be null)
|
PROCEDURE_SCHEM
|
String
|
procedure schema (may be null)
|
PROCEDURE_NAME
|
String
|
procedure name
|
REMARKS
|
String
|
explanatory comment on the procedure
|
PROCEDURE_TYPE
|
short
|
kind of procedure:
procedureResultUnknown - May return a result
procedureNoResult - Does not return a result
procedureReturnsResult - Returns a result
|
Syntax
getProcedures(string catalog, string schemaPattern,string procedureNamePattern)
Parameters
catalog
A catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria
schemaPattern
A schema name pattern; "" retrieves those without a schema
procedureNamePattern
A procedure name pattern
|
