Long time Oracle PL/SQL coder but new to MySQL.

I have an error handler that looks like this ...

declare continue handler for sqlexception
begin
get diagnostics condition 1 @p3 = returned_sqlstate, @p4 = message_text;
set v_there_was_an_error_while_inserting_a_lead_summary := true;

insert into rit.rit_audit_message(severity,
message,
process_name,

summary_detail_map,
createdby2qmp_user,
updatedby2qmp_user)
values ('ERROR',
concat('Something went wrong while trying to insert commission lead summaries. No summaries created! ',
@p3,
' ',
@p4),
'pop_comm_summary',

1003,
1003);

end;

So, what if the insert (shown above) throws a sqlexception?

1) What happens?
2) Is there a better way to do this? Perhaps I should not have DML in my error block?


Michael Moore