//------------------------------------------------------------------------------
// ExJDBC8Proc.java
//------------------------------------------------------------------------------

import java.sql.*;

class ExJDBC8Proc {
    public static void main(String[] args)
	throws SQLException, ClassNotFoundException {

	Class.forName("oracle.jdbc.driver.OracleDriver");
	Connection c = DriverManager.getConnection(
            "jdbc:oracle:thin:waller_a/AQWzsx34@servora:1521:dbinfo");

	// fonctionne  exactement comme pour prepared :
	String texte = "{ call anniversaire(?) }"; 

	CallableStatement cs = c.prepareCall(texte);

	cs.setString(1, "Riton");
	cs.execute();

	cs.setString(1, "Rita");
	cs.execute();

	cs.close();
	c.close();
    }
}

//------------------------------------------------------------------------------