sqlerrm is especially useful in the OTHERS exception handler because it lets you identify which internal exception was raised.
You can pass an error number to sqlerrm, in which case sqlerrm returns the message associated with that error number. The error number passed to sqlerrm should be negative.