marcelocbf
asked on
MySQL: Rollback Insert through BEFORE Triggers
Hi,
I'd like to rollback a Insert statement is my check in the BEFORE INSERT trigger don't satisfy a condition ...
I read somewhere that any exception during the trigger would prevent the insert, but I don't know how throw this exceptions ...
Can someone help me ?
Thanks,
I'd like to rollback a Insert statement is my check in the BEFORE INSERT trigger don't satisfy a condition ...
I read somewhere that any exception during the trigger would prevent the insert, but I don't know how throw this exceptions ...
Can someone help me ?
Thanks,
raise_application_error(-1 0001,'Erro r in Insert');
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Sorry for the delay ...
I'll study your solution ... Thanks
I'll study your solution ... Thanks