Raise application error trigger

Hello All,

I have the following quesions about this trigger!

String orderT = "CREATE TRIGGER orderT BEFORE UPDATE ON orders " +
"FOR EACH ROW " +
"BEGIN " +
"IF (deliveryStatus = 'paid' AND paymentStatus = 'paid') THEN " +
"RAISE_APPLICATION_ERROR(-20000, 'A completed order cannot be updated') " +
"END IF " +
"END";

This is my trigger in the form of a Java string. Do i have to embed any semi colons in it?

Here is my trigger in a more easy to read form. Of course, it does not work. Triggers are the most annoying thing I have come across!

CREATE TRIGGER orderT BEFORE UPDATE ON orders
FOR EACH ROW
BEGIN
IF (deliveryStatus = 'delivered' AND paymentStatus = 'paid') THEN
RAISE_APPLICATION_ERROR(-20000, 'A completed order cannot be updated') <--- WOULD I HAVE TO PUT A ; HERE?
END IF
END

Also, does anyone know why I get a validation error with this one?

The purpose of this trigger it to prevent modifications being made to an order tuple if deliveryStatus = delivered and paymentStatus = paid in that tuple.

Thanks

Chris

every statement must have a semi-colon as a terminator. DECLARE and BEGIN do not as they are considered complete with and END; statement. END IF must also be followed by a semi-colon

You need permissions, plus you may also have grant permissions. Ask your DBA for help.