org.firebirdsql.jdbc

Interface StoredProcedureMetaData

public interface StoredProcedureMetaData

Meta-information on stored procedures in a Firebird database.

Method Summary

Modifier and Type	Method and Description
boolean	canGetSelectableInformation() Determine if the "selectability" of procedures is available.
boolean	isSelectable(java.lang.String procedureName) Retrieve whether a given stored procedure is selectable.

Method Detail

canGetSelectableInformation

boolean canGetSelectableInformation()

Determine if the "selectability" of procedures is available. This functionality is only available starting from Firebird 2.1, and only with databases created by that version or later.

Returns:

true if selectability information is available, false otherwise

isSelectable

boolean isSelectable(java.lang.String procedureName)
              throws java.sql.SQLException

Retrieve whether a given stored procedure is selectable. A selectable procedure is one that can return multiple rows of results (ie it uses a SUSPEND statement).

Parameters:

procedureName - The name of the procedure for which selectability information is to be retrieved

Returns:

true if the procedure is selectable, false otherwise

Throws:

java.sql.SQLException - If no selectability information is available