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!

How to resolve ORA-00001 Error in SQL Insert?

807089Jul 15 2012 — edited Jul 15 2012

Hi all, I need your appreciated help.

I make a plsql procedure that is inserting a row according cursor value, I'm having oracle error ORA-00001: unique constraint (constraint_name) violated.

You may see this message if a duplicate entry exists at a different level: in RDBMS MySQL I have the syntax IGNORE to resolve this duplication error... and in Oracle ?

Thanks for your time and hints.
Miguelito

This post has been answered by Solomon Yakobson on Jul 15 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 12 2012

Added on Jul 15 2012

6 comments

13,819 views