Skip to Main Content
Forums

SQL & PL/SQL

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!

Raise Exception for Insert Statement

Yathish NaikNov 12 2009 — edited Nov 16 2009
Hello All,

Hope everyone know that when we try to do an Insert on a table in two different session with the same unique key then in the second session the application will hang.

Instead of hanging or waiting in another session, do we have any option to raise an Exception saying "Parallel Duplicate insertion is active." or to do Insert with NOWAIT so that it throws an Error.


Thanks in advance.

Regards,
Yathish
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 14 2009
Added on Nov 12 2009
#insert
5 comments
2,804 views