title: fire trigger after insert in oracle
body: <p>I'm very new for trigger,  now this what i was trying. I've two tables <strong>INSERTED</strong> and <strong>ORDER_INFO</strong>, both have the same column name <strong>ORDER_ID</strong>, <strong>ORDER_DATE</strong>. I've scenario, where client will be placing his/her order then, order information will be stored into <strong>INSERTED</strong> table, then by using this trigger, it'll insert into another table <strong>ORDER_INFO</strong> after satisfying the condition, which has been written.</p>
  
  <pre><code>    create trigger tri_check
  AFTER INSERT ON inserted FOR EACH ROW
  DECLARE
   v_date DATE;
  BEGIN
      SELECT order_date INTO v_date FROM inserted;
  if (v_date)&lt; (sysdate + 2) then
   raiserror('You cannot take an order to be delivered less than 2 days from now',16, 1);
  else
  INSERT INTO orders_info
       ( order_id,order_date)
      VALUES
       (:new.order_id,v_date);
  end if;
  end;
  </code></pre>
  
  <p>But, when i'm executing the above trigger, then i'm getting this error.</p>
  
  <pre><code>ERROR at line 8: PL/SQL: SQL Statement ignored
  6.     SELECT order_date INTO v_date FROM inserted;
  7. if (v_date)&lt; (sysdate + 2) then
  8.  raiserror('You cannot take an order to be delivered less than 2 days from now',16, 1);
  9. else
  10. INSERT INTO orders_info
  </code></pre>
  
  <p><strong>EDIT</strong></p>
  
  <p>Now, i made the same structure table into <strong>SYSTEM</strong> user, and got the same error. <code>Table or View does not exist</code></p>
  
  <p>Need help !! Thanks in advance !!</p>