Jul 25 2009

ORA-00001: unique constraint (METALINK.SYS_C005417) violated

Tag: UncategorizedChristian Antognini @ 12:45 pm

ORA-00001: unique constraint (METALINK.SYS_C005417) violated

This is a partial screenshot of an application without a decent error handling.

Do you recognize it?

It goes without saying that no further comments are needed…

3 Responses to “ORA-00001: unique constraint (METALINK.SYS_C005417) violated”

  1. Comment: Gary

    Forget the application, they should be giving their unique constraints some sort of reasonable name.

  2. Comment: Christian Antognini

    Hi Gary

    I fully agree with you about the name of unique constraints. But, IMHO, the name of the constraints is much less important than the error handling…

    Cheers,
    Chris

  3. Comment: Mette

    Grin … maybe they are having trouble FINDING the code produing the error – if the developers are not allowed access
    to prodcution environment definitions, it can be rather tedious to find a constraint with quite another
    name in test & dev environments. I HATE unnamed constraints …..

Leave a Reply

All comments are filtered by Akismet and then moderated by me. So, it should be no surprise that spam and anything wholly inappropriate has no chance of making it onto the site. To send questions or comments not related to this blog post please use the contact form.

Your name (required)

Your email (will not be published) (required)

Your website

Your message (please wrap code examples in <pre> tags)