------------------------------------------------------------------------------- -- proc_td4b.sql -- tourne le 25 janvier 2017, 13:55 -- materiel simplifie pour appeler procedures au TD4b (BD2Miage) ------------------------------------------------------------------------------- create sequence seq_village start with 10; create or replace procedure creerVillage( v varchar2, a varchar2, p int, c int) is begin insert into village values( seq_village.nextval, v, a, p, c); end; / show errors ------------------------------------------------------------------------------- create or replace function traitement3(le_jour sejour.jour%type) return integer is begin return -1; end; / ------------------------------------------------------------------------------- create or replace procedure traitement3_out( le_jour sejour.jour%type, le_nombre out integer) is begin le_nombre := -1; end; / -------------------------------------------------------------------------------