This content has been marked as final. Show 6 replies
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.