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) {
}
Post a comment