org.firebirdsql.jdbc

## Interface StoredProcedureMetaData

-     public interface StoredProcedureMetaData

  Meta-information on stored procedures in a Firebird database.

- - ### Method Summary

    Methods
    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

Copyright © 2001-2021 Jaybird (Firebird JDBC/JCA) team. All rights reserved.