i'm deloping a windows forms database application

in that i inserted one row and agin i'm trying to insert that row.

obviously, we get the error ora-00001

we can handle that error using 'Exception'

are there any predefined exception handlers for this error

if not ,pls explain me how to handle that error in a user friendly manner?

pls help me

thanling you

chaitanya m.

Hi Chaitanya.M,

Ora-00001 is an oracle error code for "unique constraint violated". One solution is to check before insert/update, that can avoid insert/update duplicate value to a unique column. The other way is catch the exception message and replace it with your own word.
E.g.
catch (Exception exp)
{
if (exp.Message.Contains("ora-00001"))
{
throw new Exception("Cannot insert duplicate value to XXX column!");
}
}

Sincerely,
Kira Qian

---

Please mark the replies as answers if they help and unmark if they don't.

Hi Chaitanya.M,

Ora-00001 is an oracle error code for "unique constraint violated". One solution is to check before insert/update, that can avoid insert/update duplicate value to a unique column. The other way is catch the exception message and replace it with your own word.
E.g.
catch (Exception exp)
{
if (exp.Message.Contains("ora-00001"))
{
throw new Exception("Cannot insert duplicate value to XXX column!");
}
}

Sincerely,
Kira Qian

---

Please mark the replies as answers if they help and unmark if they don't.

thak u very much