Getting Success or Failure Detection in Stored Procedure

I have a stored procedure that has a simple insert statement. I want to
be able to tell if the insert statement executed successfully, and
return using a tinyint whether the statement was successful or not. My
googling efforts did not result in anything useful, probably because I
do not know the proper terminology. I am using mysql-5.0.18-nt. So,
the question is, what syntax is used to trap a result code from an
insert query, and what specific code is for success, assuming that any
other code is a failure. At this point I don't need to know what the
failure is, though at some point I might start logging these.

Marc