Oracle Error ORA-29917: cannot lock a table which gets its rows from a collection operand

Oracle Error Message

ORA-29917: cannot lock a table which gets its rows from a collection operand

Reason for the Error

Tables which gets its rows from a collection operand cannot be locked

Solution

Don’t lock the table