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?
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.
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.
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
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: 7880
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!
Re: Exceptions no_data [message #269654 is a reply to message #269628] Mon, 24 September 2007 00:31 Go to previous message
BlackSwan
Messages: 25050
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.
Previous Topic: problem in time manipulation in query..
Next Topic: Creating Pivot
Goto Forum:
  


Current Time: Fri Dec 09 23:10:08 CST 2016

Total time taken to generate the page: 0.07653 seconds