package org.kodejava.example.sql;

import java.sql.*;

public class StoredProcedureListExample {
    private static String url = "jdbc:oracle:thin:@localhost:1521:xe";
    private static String username = "kodejava";
    private static String password = "welcome";

    public static void main(String[] args) throws Exception{
        Connection conn = getConnection();

        try {
            DatabaseMetaData metadata = conn.getMetaData();
            ResultSet result = metadata.getProcedures(null, "KODEJAVA", "%");
            while (result.next()) {
                System.out.println(result.getString("PROCEDURE_CAT")
                        + " - " + result.getString("PROCEDURE_SCHEM")
                        + " - " + result.getString("PROCEDURE_NAME"));
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            closeConnection(conn);
        }
    }

    private static Connection getConnection() throws Exception{
        Connection conn = null;
        try {
            Class.forName("oracle.jdbc.driver.OracleDriver");
            conn = DriverManager.getConnection(url, username, password);
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
            throw new Exception(e);
        } catch (SQLException e) {
            e.printStackTrace();
            throw new Exception(e);
        }
        return conn;
    }

    private static void closeConnection(Connection conn) throws SQLException {
        if (conn != null && !conn.isClosed()) {
            conn.close();
        }
    }
}

• About
• Latest Posts

Wayan Saryada

Founder at Kode Java Org

I am a programmer, a runner, a recreational diver, currently live in the island of Bali, Indonesia. Mostly programming in Java, Spring Framework, Hibernate / JPA. You can support my works by donating here. Thank you 🙂.

Latest posts by Wayan Saryada (see all)

• How do I write JSON string using JSON-Java (org.json) library? - August 31, 2018
• How do I read JSON file using JSON-Java (org.json) library? - August 31, 2018
• Install IntelliJ IDEA Community Edition and Write Hello Kotlin Program - May 13, 2018