create or replace procedure add_zd(soid in number,sdate in date,ye in number, monthsr in number,monthzc in number)
asbegin
dbms_output.put_line(sdate);
insert into allso( soid,sodate,ye,s,ou) values(soid,sdate,ye,monthsr,monthzc);
end;
call add_zd(3,to_date('2015-12-01','yyyy-mm-dd'),5000,10000,-5000);
select * from allso