Three ways to get error message/stack in PL/SQL

Hi All

Today I speak about how manage errors in PLSQL.

This link speaks about three ways to manage errors in PLSQL, it's very clear and complete.

Basically, exists three forms to manage it :

• SQLERRM
• DBMS_UTILITY.FORMAT_ERROR_STACK
• UTL_CALL_STACK API (From Oracle 12c version)

I invite you to read the link for more details.

Stay tuned.