Dear Mahesh,
Pls help me in solving this issue.
Iam using VB.NET and Oracle in my application.
In the front end , when I click a button, iam calling an SP in the backend, since that
calling process takes longer time( SP keeps running in the backend) and the application hangs. Later, when I recompile the SP, it says "Timeout occured while waiting for lock".
So we need to restart the IIS and if we compile again, it works.
So how to avoid SP Locking? (SP itself is getting locked, not the Transaction)
Pls help me.
Regards
deepa
Posted Oct 16, 2007, 1:43 AM
hi deepa y dont u try like this
I don't know if there is a better way, but you can certainly
make it lock a specific datum as it's first step, and release it
at the end. This way any second user running the procedure will hang
at the first step till the first runner is finished:
Pseudocode:
create proc myproc as
begin
begin tx
update my_single_row_proc_lock_table set val = 0 -- locks the one row in the table
...do all you want...
commit tran
end