Tuesday, 11 October 2011

SQL Code & SQLERRM

{\rtf1\ansi\ansicpg1252\deff0\deflang16393{\fonttbl{\f0\froman\fprq2\fcharset0 Times New Roman;}{\f1\fnil\fcharset0 Calibri;}}
{\*\generator Msftedit 5.41.21.2509;}\viewkind4\uc1\pard\lang1033\b\f0\fs24\par
\pard\li1080\b0\fs22 SQLCODE returns the value of the error number for the last error encountered. The SQLERRM returns the actual error message for the last error encountered. They can be used in exception handling to report, or, store in an error log table, the error that occurred in the code. These are especially useful for the WHEN OTHERS exception.\par
\pard\li720\par
\pard\sa200\sl276\slmult1\lang9\f1\par
}

No comments:

Post a Comment