1.创建存储过程(异常处理)
create or replace procedure pro_test2(dmlb in varchar2,dmz in varchar2,dmsm1 in varchar2,dmsm2 in varchar2,dmsm3 in varchar2,dmsm4 in varchar2,returnvalue out integer) is
begin
insert into veh_type values(dmlb,dmsm1,2,2);
insert into veh_code values(dmlb-1,dmz,dmsm1,dmsm2,dmsm3,dmsm4);
commit;
returnvalue:=1;
exception
when others then
rollback;
returnvalue:=0;
end pro_test2;
2.调用存储过程
declare returnvalue integer;
begin
pro_test2(999,'aa','a1','','','',returnvalue);
dbms_output.put_line(returnvalue);
end;