// APP3_corr_td4b.java

// create or replace procedure creerVillage(
//    v varchar2, a varchar2, p int, c int)

	String texte = "{ call creerVillage('Rio', 'kitesurf', 10, 25) }"; 
	CallableStatement cs = c.prepareCall(texte);
	cs.execute();
	cs.close();

	texte = "{ call anniversaire('"+n+"') }"; 

// create or replace function traitement3(
//    le_jour sejour.jour%type)
//    return integer

	texte = "{ ? = call traitement3(165) }"; 
	cs = c.prepareCall(texte);
	cs.registerOutParameter(1, Types.INTEGER);
	cs.execute();
	System.out.println(cs.getInt(1));
	cs.close();

	lireClavier("tapez return 3 :");

	texte = "{ call age_out('Rita',?) }"; 
	// rem : exactement pareil (5 lignes) que ci-dessus :
	cs = c.prepareCall(texte);
	cs.registerOutParameter(1, Types.INTEGER);
	cs.execute();
	System.out.println(cs.getInt(1));
	cs.close();

	lireClavier("tapez return 4 :");

    	texte = "{ call deux_out('Rita',?,?) }"; 
	cs = c.prepareCall(texte);
	cs.registerOutParameter(1, Types.INTEGER);
	cs.registerOutParameter(2, Types.INTEGER);
	cs.execute();
	System.out.println(cs.getInt(1));
	System.out.println(cs.getInt(2));
	cs.close();
}

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