6 Replies Latest reply on Aug 8, 2013 7:47 PM by amit srivastava

    FRM-40743: This operation with no base table requires the LOCK-PROCEDURE trigger

    amit srivastava

      Hello All,


      I am getting FRM-40743 while inserting data into a table. I know I should write a UPDATE, LOCK, INSERT in procedure based block.

      The issue is that I am querying data from another table and I have to select some  data and insert into another table, which will not have record to lock. So I am not able to lock the table in which I have to insert data.


      Please help me or suggest how can I achieve this.