Oracle存储过程实例

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;