SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Serialization with wait

875308Aug 29 2011 — edited Sep 14 2011

Hi,

I am using dbms_sleep() while implementing serialization.
This returns error message for a session, while another session is in process
declare
*
ERROR at line 1:
ORA-20001: Timed Out - As another session is Running the application
ORA-06512: at line 7

I dont want error message to be displayed,while application is waiting to acquire the lock.

Could you please help me?

Thank You,
-Aparna

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 12 2011

Added on Aug 29 2011

#sql-developer

1 comment

100 views