This section describes how to get a list of stored procedures in the database server.
If you want to get a list of stored procedures through the JDBC interface,
you can use the getProcedures() method on the DatabaseMetaData object
as shown in the program program below:
/**
* OracleCallGetProcedures.java
* Copyright (c) 2007 by Dr. Herong Yang. All rights reserved.
*/
import java.sql.*;
public class OracleCallGetProcedures {
public static void main(String [] args) {
Connection con = null;
try {
oracle.jdbc.pool.OracleDataSource ds
= new oracle.jdbc.pool.OracleDataSource();
ds.setDriverType("thin");
ds.setServerName("localhost");
ds.setPortNumber(1521);
ds.setDatabaseName("XE");
ds.setUser("Herong");
ds.setPassword("TopSecret");
con = ds.getConnection();
DatabaseMetaData meta = con.getMetaData();
// Listing all stored procedures
ResultSet res = meta.getProcedures(null, "HERONG", "%");
System.out.println("Stored procedures:");
while (res.next()) {
System.out.println(
" "+res.getString("PROCEDURE_CAT")
+ ", "+res.getString("PROCEDURE_SCHEM")
+ ", "+res.getString("PROCEDURE_NAME"));
}
res.close();
// Listing all tables
res = meta.getTables(null, "HERONG", "%", null);
System.out.println("Stored tables:");
while (res.next()) {
System.out.println(
" "+res.getString("TABLE_CAT")
+ ", "+res.getString("TABLE_SCHEM")
+ ", "+res.getString("TABLE_NAME"));
}
res.close();
con.close();
} catch (Exception e) {
System.err.println("Exception: "+e.getMessage());
e.printStackTrace();
}
}
}
Note that there were some tables named as "BIN$..." in the database. Those tables were copies of dropped tables stored in the recycle bin
just in case you want to restore them.
