Data Warehousing Community Forum
February 08, 2012, 11:00:53 am

Pages: [1]   Go Down
« previous next »
  Print  
Author Topic: SQLCODE and SQLERRM  (Read 1220 times)
Sipra
Founder
*****

Reputation: +59/-0
Offline Offline

Posts: 323


Am the King...


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

Hi,

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?
Logged
Sipra
Founder

www.dwforum.net
Whoever
Administrator
*****

Reputation: +34/-0
Offline Offline

Posts: 124



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
If most people said what’s on their minds, they’d be speechless.
Pages: [1]   Go Up
  Print  
« previous next »
 
Jump to: