Hi, My triggers performs a lot of verifications over the data before insert or update. So I need make all checks, and at the end, RAISE EXCEPTION msgsErrors; and the variable msgsErrors containing all Error Messages reported by hole trigger. But the RAISE EXCEPTION don't accept variables, only a CONTANT STRING. Nor strigs concatenation are supported ........ I'm make any mistake ? Exist any way to do that ? Regards, Tulio Oliveira
- Re: [GENERAL] Problems with RAISE EXCEPTION Tulio Oliveira
- Re: [GENERAL] Problems with RAISE EXCEPTION Bruce Richardson