The Java Developers Almanac 1.4

Home > List of Packages > java.sql [73 examples] > Procedures and Functions [4 examples]

e280. Getting the Stored Procedure Names in a Database

This example retrieves the names of all stored procedures in a database.

    try {
        // Get database metadata
        DatabaseMetaData dbmd = connection.getMetaData();
    
        // Get all stored procedures in any schema and catalog
        ResultSet resultSet = dbmd.getProcedures(null, null, "%");
    
        // Get stored procedure names from the result set
        while (resultSet.next()) {
            String procName = resultSet.getString(3);
        }
    } catch (SQLException e) {
    }

Related Examples

e281. Calling a Stored Procedure in a Database
e282. Calling a Function in a Database
e283. Creating a Stored Procedure or Function in an Oracle Database

See also: Batching Connections Database Meta Data Deleting Data Drivers Importing and Exporting Inserting and Updating Data Oracle OBJECTs Oracle VARRAYs Retrieving Data Scrollable Result Sets Tables Updatable Result Sets

© 2002 Addison-Wesley.