drop table vendors;
create table vendors (

  vendor_id          number  primary key,
  url                varchar2(255),
  the_user           varchar2(80),
  password           varchar2(80) );
insert into vendors

  ( vendor_id, url, the_user, password )
  values
  ( 1,
    --
    -- modify this data for your site
    --

    'http://bllewell-sun.us.oracle.com/pls/vendor/receive_order',
    --
    --  uncomment this line to fabricate an error and cause an error email to be sent
    --  'http://bllewell-sun.us.oracle.com/pls/vendor/Nonexistent',
    'my_vendor',
    'my_password' );
commit;