martedì 8 marzo 2022

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.





alle
Etichette: , ,

Nessun commento:

Posta un commento

Iscriviti a: Commenti sul post (Atom)

Check Mid Year Objectives

Hi all Today middle year check of my 2026's goals. 1. ENGLISH Improve listening comprehension (So and So)   See at least one or two film...

  • DBeaver
    Hi all Today I want speak about one of the best DB Client tool in the market : DBeaver  . Why it's so good :  1) It's an open source...
  • Goals 2025
     Hi all Today, first day of 2025 my goals for this year : 1. ENGLISH Improve listening comprehension  See at least one or two films in Engli...
  • CUBE and ROLLUP options in GROUP BY
    For my actual project i am studying CUBE and ROLLUP option in GROUP BY. These options are present from Oracle 8i and are very interesting : ...