HOW CAN I CAPTURE DE ERROR

[Fabio Deodoro]

Hi everybody!

I have the following procedure:

CREATE PROCEDURE `vivianadv`.`ins_cli` (IN v_cpf CHAR(11) , IN v_estado_civil CHAR(1), OUT v_retorno INT)
BEGIN
INSERT INTO `vivianadv`.`cli` (cpf, estado_civil) VALUES (v_cpf, v_estado_civil);
END

Supose, for any reason, the INSERT statment returned a error.
How can I capture the error code or the success code of INSERT statement?

Can I set de error code or success code to my param v_retorno?

Thank's a lot!!!