Hi.
I call raiserror with a custom message. Does anyone knows how to capture it ?
For example -
----
raiserror 21000 ....
----
exception
when others
if sqlcode=21000
delete mytable;
resignal;
end if
end

In this case delete mytable removes my error and resignal does nothing.

Any solution?

Gabriel Popa