Errors file and some more

[Bart Pietercil]

Hi Ruslan, list,


1) I'm looking for the errors xml file. I know it exists, I don't know  
how it is called and I don't know where it is stored.

2) In the process of trying to write clean code I found this on the wiki

CREATE TABLE t1 ( f1 LONG UNIQUE );

BEGIN
     INSERT INTO t1 VALUES(1);
     INSERT INTO t1 VALUES(1);
EXCEPTION
     WHEN ERR_CONSTRAINT_UNIQUE_VIOLATION THEN
         PRINT 'Unique violation'
END;

This  ERR_CONSTRAINT_UNIQUE_VIOLATION seems to do exactly what I need  
(check for duplicate exception).
However when I try to use this it is not recognised by the sql parser  
(when trying to put it in).
I think that is a shame (from a productivity standpoint), but maybe  
there are technical reasons for it ...

I suppose I will find those constant names also in the errors xml file ?

May I suggest putting the location of this page on the wiki page on  
exception handling.
Maybe also put a link to the page (for consultancy reasons) also on  
the wiki ?

tia

Bart Pietercil