Dead Lock

[SANCHIT SHARMA]

We are using procedures for DML and DDL actions. From the procedure we want to handle Loacking Mechanish. Ex. If one transaction is open by user 1 , the record should automatically attain lock. If some other user wnats to get access to the same record, immediately there should be a prompt, Already this transaction is use by a user. Pls attempt other transaction. Or you can only view the same...

In Oracle this can easily be handled by raising exception. But how to overcome the same in SQL, by introducing the exception handling within the procedure..


Pls Help. If any detailed procedure , handling the same pls provide us to get the indepth knowledge..

Regards.