Trigger to display error

[james0816]

I am trying to create a trigger that will display an error custom error message but can not get the syntax correct. I thought it was something to the effect of:

...
begin
raiserror 999 ''You have encountered an error'';
end;

This unfortunately is not working. Can someone lend some advice? Thanks.

 

[lewisp]

[tt]DECLARE
your_error EXCEPTION;
BEGIN
Raise your_error;
EXCEPTION
WHEN your_error
THEN
Do_Something;
END;