import  oracle.jdbc.OracleTypes;

 import  java.sql.*;

 public   class  MetadataTest {

   private   static   final  String USERNAME = "<username>";

   private   static   final  String PASSWORD = "<password>";

   private   static   final  String SERVER = "jdbc:oracle:thin:@<host>:<port>:<SERVICE_NAME>";

   public   static   void  main(String args [])
     throws  Exception {
    Connection con =  null ;
    CallableStatement cst =  null ;
    ResultSet rs =  null ;
     try  {
      DriverManager.registerDriver( new  oracle.jdbc.OracleDriver());
      con = DriverManager.getConnection(SERVER, USERNAME, PASSWORD);
      cst = con.prepareCall(
        "begin\n" +
        "  open :cr for\n" +
        "    select * from scott.emp;\n" +
        "end;"
      );
      cst.registerOutParameter( 1 , OracleTypes.CURSOR);
      cst.execute();
      rs = (ResultSet) cst.getObject( 1 );
      ResultSetMetaData rsMetaData = rs.getMetaData();
       for  ( int  i =  1 ; i <= rsMetaData.getColumnCount(); i++) {
        System.out.println(rsMetaData.getColumnName(i) + " " + rsMetaData.getColumnTypeName(i));
      }
    }  finally  {
       if  (rs !=  null ) { rs.close(); }
       if  (cst !=  null ) { cst.close(); }
       if  (con !=  null ) { con.close(); }
    }
  }

}

Statement st = con.createStatement();
ResultSet rs = st.executeQuery("select * from scott.emp");
ResultSetMetaData rsMetaData = rs.getMetaData();