Skip to Main Content

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!

Exception handling in a stored procedure

1024243Aug 27 2013 — edited Aug 27 2013

Hello,

I have a stored procedure with one IN parameter that  insert values in a table as a treatment ,and i have to define an exception that raise when the same row is inserted several times (the row should be inserted one time).

do you have any idea of what is the request that should i write to do that (verify the existence of a row)??

PS : I'm just a beginner in PL/SQL

Regards,

AC

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 24 2013
Added on Aug 27 2013
6 comments
731 views