import java.sql.*;
import oracle.jdbc.driver.*;

public class Ex1 {
  public static void main(String[] args)
    throws SQLException, ClassNotFoundException {
    Class.forName("oracle.jdbc.driver.OracleDriver");

    Connection conn = DriverManager.getConnection(
        "jdbc:oracle:thin:@s10:1521:orcl",
        "senellar_a",
        "senellar_a");

    CallableStatement cstmt=conn.prepareCall("{?=call curseur_pour_prenom(?)}");

    String prenom=args[0];
    
    cstmt.setString(2,prenom);
    cstmt.registerOutParameter(1,OracleTypes.CURSOR);
    cstmt.execute();

    ResultSet rset=(ResultSet) cstmt.getObject(1);

    while(rset.next()) {
      System.out.println(prenom+" -> "+rset.getString(1));
    }

    conn.close();
  }
}