$sql.metaData.getProcedures

Retrieves a description of the stored procedures available in the given catalog.

Syntax	$sql.metaData.getProcedures{jdbcProfileName}{String catalog}{String schemaPattern}{String procedureNamePattern}
Documentation	Retrieves a description of the stored procedures available in the given 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 reserved for future use reserved for future use reserved for future use 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 : Paramter: catalog - a catalog name; must match the catalog name as it is stored in the database; "" retrieves those without a catalog; null means that the catalog name should not be used to narrow the search schemaPattern - a schema name pattern; must match the schema name as it is stored in the database; "" retrieves those without a schema; null means that the schema name should not be used to narrow the search procedureNamePattern - a procedure name pattern; must match the procedure name as it is stored in the database Returns: ResultSet - each row is a procedure description Throws: SQLException - if a database access error occurs
Examples

Group	SQL
Minimum required transaction-mode:	NONE
Required scripting permission of the developer	PERMISSION_FL_BASIC
Minimum parameters	4
Maximum parameters	4