thanks for quick reply,

well the situation is that i have a huge sql built up at runtime, which include some date checks like records from to periods .

select * from...

Yes that was the problem, the after execution of the procedure the connection wasnt commited and hence the table was blocked. Thanks for your help.

cheers

have a good day.

Thanks for the reply thou that did not help much, when i call the procedure thru sql anyalyzer it works fine but when i call it thru java and try...