Home » SQL & PL/SQL » SQL & PL/SQL » Exceptions (Oracle 10g)
Exceptions [message #289827] Wed, 26 December 2007 04:20 Go to next message
subbu_tce
Messages: 98
Registered: July 2007
Location: pune
Member
Dear All,

To handle the no data found exception i have to use no_data_found.Even if i use when "others" system will work.
so what is the difference between using no_data_found and others.
Re: Exceptions [message #289841 is a reply to message #289827] Wed, 26 December 2007 04:43 Go to previous messageGo to next message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
"no_data_found" only catches "no data found" error.
"others" catches all and any error.

PL/SQL User's Guide and Reference
Chapter 10 Handling PL/SQL Errors

Regards
Michel
Re: Exceptions [message #310118 is a reply to message #289827] Mon, 31 March 2008 06:11 Go to previous messageGo to next message
krishna.apps
Messages: 3
Registered: March 2008
Location: Chennai
Junior Member
If you use appropiate exception handler, it wil handle.. otherwise others wil take for all the exception handlers...

Regards.
Re: Exceptions [message #310122 is a reply to message #310118] Mon, 31 March 2008 06:21 Go to previous message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
It took you 3 months to repeat what I said?

Good to see you want to help but put your effort in newer and unanswered topic.

Regards
Michel
Previous Topic: Sync two tables through dblink
Next Topic: What problem in this SQL statement?
Goto Forum:
  


Current Time: Tue Feb 11 02:04:09 CST 2025