-- Stored procedure add_order

create or replace procedure add_order
    (onum IN orders.ono%type,
     cnum IN orders.cno%type,
     enum IN orders.eno%type,
     receive IN date) as
  begin
    if (receive is null) then
      insert into orders
        values (onum,cnum,enum,sysdate,null);
    else
      insert into orders
        values (onum,cnum,enum,receive,null);
    end if;
  exception
    when others then
      rollback work;
      insert into orders_errors
        values(sysdate,onum,'error inserting order'); 
  end;
/
show errors