trapping error code and error message.

["Ananda Kumar" <anandkl@xxxxxxxxx>]

Hi All,
In oracle we have these two bulit in's SQLCODE and SQLERRM, which helps use
to find the error code and error message.
Does mysql also provide any thing like this.
I want to use this in my stored proc to find out if stored proc throws any
exception apart from NO_DATA_FOUND


regards
anandkl