---------------------------------------------------------------
-- Homework hints ... two tables used for debugging 
---------------------------------------------------------------

drop table orders_errors cascade constraints;
create table orders_errors (
  tdate    date,
  ono      number(5),
  msg      varchar2(50));

drop table odetails_errors cascade constraints;
create table odetails_errors (
  tdate    date,
  ono      number(5),
  pno      number(5),
  msg      varchar2(50));