Changing Standard Error Codes

[Szhark]

Is there anyway to change the error codes defined in the STANDARD package? ie: I'd like to reword the unique constraint violation description. Is this possible?

[m1l]

You could trap them and then display whatever error you want.

[Szhark]

Can you give me a little direction on how to do that?

[bkanti]

Try using INIT_PRAGMA
I'm giving an example
DECLARE
deadlock_detected EXCEPTION;
PRAGMA EXCEPTION_INIT(deadlock_detected, -60);
BEGIN
...
EXCEPTION
WHEN deadlock_detected THEN
-- handle the error
...
END;