6 Replies Latest reply: Aug 8, 2013 2:47 PM by amit srivastava RSS

    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.

       

      Thanks.