Can I change ORA-00001:unique constraint...?

[raf]

hi,
I've table ST
NAME.........VARCHAR2(20)........PRIMARY KEY
ID..............NUMBER

INSERT INTO ST VALUES('PTS', 2);
INSERT INTO ST VALUES('PTS', 2);

I get (correctly) error ORA-00001:unique constraint (X_PK_Y) violated.

Can I change this message of error??

For example, can I get this error when I insert 2 primary key:

wrong: change your value please!



Thanks
Raf

[hemanr]

First of all that is an Oracle system error.
Why would you want to change the text of the message?

Are you trying to provide a customized message to the end user?

[marist89]

Look at exception handling.