Home » SQL & PL/SQL » SQL & PL/SQL » Exceptions no_data
Exceptions no_data [message #269628] Sun, 23 September 2007 22:39 Go to next message
srikanthvijay8
Messages: 16
Registered: July 2007
Location: Chennai pattanam
Junior Member
In a exception part, suppose
a) When No_DATA_FOUND put two times of different
codes inside . what will happen?

a) When OTHERS put two times of different
codes inside . what will happen?

Report message to a moderator

Re: Exceptions no_data [message #269633 is a reply to message #269628] Sun, 23 September 2007 22:44 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member
Only one of the When Block is executed while exception generated.

Report message to a moderator

Re: Exceptions no_data [message #269635 is a reply to message #269633] Sun, 23 September 2007 22:51 Go to previous messageGo to next message
srikanthvijay8
Messages: 16
Registered: July 2007
Location: Chennai pattanam
Junior Member
I want to know that whether
1) first when is executed?
2) second when part is executed?
3)Compilation error?
4) Run time error?
Which option is the correct solution?
tell me for both scenarios a) and b) individually.

Report message to a moderator

Re: Exceptions no_data [message #269636 is a reply to message #269628] Sun, 23 September 2007 22:57 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member
It is the time to look at,

http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14261/errors.htm#LNPLS00705

Report message to a moderator

Re: Exceptions no_data [message #269652 is a reply to message #269635] Mon, 24 September 2007 00:27 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
srikanthvijay8 wrote on Mon, 24 September 2007 05:51
I want to know that whether
1) first when is executed?
2) second when part is executed?
3)Compilation error?
4) Run time error?
Which option is the correct solution?
tell me for both scenarios a) and b) individually.

Why don't you just try this yourself? These are so easy to test!

Report message to a moderator

Re: Exceptions no_data [message #269654 is a reply to message #269628] Mon, 24 September 2007 00:31 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Why don't you just try this yourself? These are so easy to test!
That would require competence, knowledge & ability.
OP is can seemingly only ask questions & not provide ANY answers.

Report message to a moderator

Previous Topic: problem in time manipulation in query..
Next Topic: Creating Pivot
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Feb 06 20:25:35 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.