I have multiprocessing C program use oracle PL/SQL,
The parent process should lock the table
lock table tbl1 in exclusive mode nowait;
and childs can ONLY commit .
if the childs commit work , does that means locking on the table will be released ?
Note : i need to prevent another instance of the program from running by check if the table is locked then exit.
Leave an answer