Data Warehousing Community Forum
October 24, 2019, 01:18:55 am

Pages: [1]   Go Down
Author Topic: SQLCODE and SQLERRM  (Read 4062 times)

Reputation: +56/-0
Offline Offline

Posts: 354

Am the King...

View Profile WWW
« on: June 29, 2007, 11:42:28 am »


What are SQLCODE and SQLERRM ?

For PL/SQL developers, why these terms are very important?
Can anybody define them both and their impotance in PL/SQL?


Reputation: +55/-0
Offline Offline

Posts: 145

View Profile WWW
« Reply #1 on: June 29, 2007, 02:06:59 pm »

For PL/SQL Developers, these terms are very important because these both gives the info about the last error that encountered in the block.

SQLCODE - It returns the value of the error number for the last error encountered.

SQLERRM - It returns the actual error message for the last error encountered.

        These terms can be used in Exceptional Handling to report or store in an error-log table, the error that occured in the code.

        These are especially useful for the "When Others" Exception.
« Last Edit: June 29, 2007, 02:09:39 pm by mOrpheuS » Logged

Wenn ist das Nunstück git und Slotermeyer? Ja! … Beiherhund das Oder die Flipperwaldt gersput.
Pages: [1]   Go Up
Jump to: