Home » SQL & PL/SQL » SQL & PL/SQL » Exception Handling_Unknown Error
Exception Handling_Unknown Error [message #205651] Sun, 26 November 2006 23:49 Go to next message
balumeignanam
Messages: 8
Registered: November 2006
Location: Bangalore
Junior Member

Hi all,
How can i handle the unknown Error .....
Re: Exception Handling_Unknown Error [message #205654 is a reply to message #205651] Mon, 27 November 2006 00:05 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
You can use
WHEN OTHERS THEN
to handle any error.

By
Vamsi
Re: Exception Handling_Unknown Error [message #205749 is a reply to message #205651] Mon, 27 November 2006 05:53 Go to previous message
moparthy99
Messages: 13
Registered: July 2006
Junior Member

One exception call
WHEN OTHERS then

USe these two SQLCODE,SQLERRM(Sqlcode)
then find the eeeor code and corrsponding err message also
i hope i will little help for u
Previous Topic: find character occurance
Next Topic: how to use arrays in PL/SQL
Goto Forum:
  


Current Time: Mon Dec 05 21:28:18 CST 2016

Total time taken to generate the page: 0.13072 seconds