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)

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...

  • eLEARNING
    Hi all Today i want speak about education and eLearning websites. Personally I am using  COURSERA , in this site you can find many course...
  • Oracle Nested Table - Create, Insert and Select
    Hi all Today i want to speak about oracle nested table. Basically you can define in oracle a field that is a table inserted in other tabl...
  • Dice simulator
    Today a simple shell script to simulate rolls of two dices : #!/bin/ksh fc=1 while [ fc -eq 1 ]; do clear echo ' How many rolls : \c...