The Java Developers Almanac 1.4


Order this book from Amazon.

   
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.