FORMAT_ERROR_STACK

Replace SQLERRM with the much better DBMS_UTILITY.format_error_stack. Now you will see the full error stack information -- but if the string exceeds 255 characters, you get an ERROR!

DBMS_OUTPUT.PUT_LINE (DBMS_UTILITY.format_error_stack);

FORMAT_ERROR_STACK

Replace SQLERRM with the much better DBMS_UTILITY.format_error_stack. Now you will see the full error stack information -- but if the string exceeds 255 characters, you get an ERROR!

DBMS_OUTPUT.PUT_LINE (DBMS_UTILITY.format_error_stack);