What is the output of the following pl/sql block ?declare v_empno emp.empno%type;begin select empno into v_empno from emp where empno = 10;exception when others then dbms_output.put_line ( 'no data found'); when no_data_found then dbms_output.put_line ( 'ther is no data found ');end;

Suryam

• Oct 18th, 2005

 

always when others exception should be the last exception handling in sequence.

Neerajms

 Profile Answers by Neerajms 

• Nov 21st, 2005

 

When Others is always handeled at the very end of all handeled exceptions. In this others should be in the last means after No_data_Found.

Lavanya Chowdary

• May 6th, 2007

 

If you are using the exception part in the prg "others" exception should be the last exception that is the only mistake in the program.

ramyaselvi16

 Profile Answers by ramyaselvi16 Questions by ramyaselvi16

• Jun 26th, 2008

 

    I think It will work,

declare
v_empno emp.empno%type;
begin
select empno into v_empno from emp where empno = 10;
exception
when no_data_found then
dbms_output.put_line ( 'ther is no data found ');
when others then
dbms_output.put_line ( 'no data found');
end;


Rgds

Ramya

nandk.sharma

 Profile Answers by nandk.sharma 

• Jun 27th, 2008

 

The above PL/SQL code will throw an oracle exception ORA - 06550.

This is due the fact that the 'OTHERS'  exception block must be at the last of all the exception in a BEGIN END block.

In the above code if we put the no_data_found exception in the first place and the others exception after that  then the  code will work properly.

neerajalatha

 Profile Answers by neerajalatha 

• Jul 5th, 2010

 

when others then
*
ERROR at line 6:
ORA-06550: line 6, column 2:
PLS-00370: OTHERS handler must be last among the exception handlers of a block
ORA-06550: line 0, column 0:
PL/SQL: Compilation unit analysis terminated

This is right answer

kiran_marla

 Profile Answers by kiran_marla 

• Jul 6th, 2010

 

Error occurs, why because "when others" must and should be placed at last in exception block