title: I am incrementing the value and update it to the table
body: <pre><code>create or replace trigger trans_s_t5
  after insert
  on trans_s
  for each row
  begin
  update :old.no_of_books
  set book_no=:old.no_of_books+1
  where book_no=:trans_s.book_no;
  end;
  </code></pre>
  
  <p>Getting error as:</p>
  
  <pre><code>PLS-00049: bad bind variable 'OLD.NO_OF_BOOKS' Compilation failed, line 3
  PLS-00049: bad bind variable 'OLD.NO_OF_BOOKS' Compilation failed, line 4
  PLS-00049: bad bind variable 'TRANS_S.BOOK_NO' Compilation failed, line 2 
  PL/SQL: ORA-00903: invalid table name Compilation failed, line 2 (10:11:17)
  PL/SQL: SQL Statement ignored 
  </code></pre>