DELETE FROM Recolte;
DELETE FROM Vin;
DELETE FROM Producteur;


-- Permet l'affichage des messages d'erreurs
SET serveroutput ON;

EXECUTE creerProducteur('Hatier','Laurent','IDF','5000');
EXECUTE creerProducteur('Wehrle','Geoffrey','Auvergne','15000');
EXECUTE creerProducteur('Machizaud','Andrea','Congo','35000');


EXECUTE creerVin('Bourgogne','2000','12');
EXECUTE creerVin('Bordeaux','2005','10');
EXECUTE creerVin('Savoie','2011','5');


EXECUTE creerRecolte('1','1','120');
EXECUTE creerRecolte('2','2','100');
EXECUTE creerRecolte('3','3','50');

EXECUTE recupererLeVin('1','ATILLA','0','0');
