8.6.62 getProcedures(String catalog, String schemaPattern, String procedureNamePattern)

(1) Function

This method acquires information about stored procedures.

To Page Top

(2) Format

public synchronized ResultSet getProcedures(String catalog, String schemaPattern, String procedureNamePattern) throws SQLException

To Page Top

(3) Arguments

String catalog

Specifies a catalog name. This argument is ignored, if specified.

String schemaPattern

Specifies a schema name pattern. This argument is ignored, if specified.

String procedureNamePattern

Specifies a procedure name pattern. This argument is ignored, if specified.

To Page Top

(4) Return value

This method always returns a ResultSet object that contains no retrieval result rows. The following table shows the format of the ResultSet object that is returned.

Table 8‒57: Format of the ResultSet object that is returned (getProcedures method)

Column No.	Type	Column name	Description
1	String	PROCEDURE_CAT	Catalog name
2	String	PROCEDURE_SCHEM	Schema name
3	String	PROCEDURE_NAME	Procedure name
4	String	RESERVE1	Reserved for future use
5	String	RESERVE2	Reserved for future use
6	String	RESERVE3	Reserved for future use
7	String	REMARKS	Description of procedure
8	short	PROCEDURE_TYPE	Procedure type
9	String	SPECIFIC_NAME	Name that uniquely identifies this procedure

To Page Top

(5) Exceptions

If this Connection object is closed before this method is executed, the JDBC driver throws an SQLException.

To Page Top