Use DBMS_UTILITY instead of SQLERRM
The function SQLERRM can be used to return an Oracle error message in PL/SQL to the calling environment.
In Oracle 10g the value which the function SQLERRM can return is something like 512,
prior to 10g it was 255.
Therefore Oracle recommends not to use this function but rather use
DBMS_UTILITY.FORMAT_ERROR_STACK instead of the SQLERRM function!!
This in fact […]