-- Stored procedure add_order_details

create or replace procedure add_order_details
    (onum      IN odetails.ono%type,
     pnum      IN odetails.pno%type,
     quantity  IN odetails.qty%type) as
  begin
      insert into odetails values (onum,pnum,quantity);
  exception
    when others then
      rollback work; 
      insert into odetails_errors
        values(sysdate,onum,pnum,'error inserting order detail'); 
  end;
/
show errors