Hi Tim,

I thought that you are looking for something on the client side.

> I have already named the constraints - how do I get the message text in
> SQL? It's easy enough to write :
>
> WHEN SQLCODE -803 DO EXCEPTION xyz
>
> but how do I get the associated text in a Stored Procedure?

I really don't know it this is possible. I don't think so. In SP's I always
check constraints before I post something.

Artur