We have 2 session and 1 table to operate with
If we want to edit, we check lock and throw an error if the table is already busy:
While load we make lock befor
And unlock after
For working with dbms_lock you need get right:
To view locks
User defined locking with DBMS_LOCKDBMS_LOCK.REQUEST (PLS5H3)
Комментариев нет:
Отправить комментарий