I have a small PL/SQL Block assume in this way begin select * from emp wher

I have a small PL/SQL Block
assume in this way
begin
select * from emp where empno=100;
exception
when others then
<Some Messages>
when no_data_found then
<Some Messages>
when too_many_rows then
<Some Messages>
end;

The question which he asked was whether this block will get
executed normally or it will throw error ?

If errored out then what is the reason for the error ?

Could anybody please help me ?
Regards
Nakul Venkataraman

Question Posted / nakul venkataraman

3 Answers
9043 Views
Satyam, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

I have a small PL/SQL Block assume in this way begin select * from emp where empno=100; except..

Answer / kavitha nedigunta

yes this will give error,
1.need to include the into clause.
(PLS-00428: an INTO clause is expected in this SELECT
statement)
2.as in exception block when others
should be at the bottom of the exception block.
(PLS-00370: OTHERS handler must be last among the exception
handlers of a block)

Is This Answer Correct ?

20 Yes

0 No

I have a small PL/SQL Block assume in this way begin select * from emp where empno=100; except..

Answer / virendra

yes this will give error, as in exception block when others
should be at the bottom of the exception block.

ex.

exception
when no_data_found then
<Some Messages>
when too_many_rows then
<Some Messages>
when others then
<Some Messages>
end;

Is This Answer Correct ?

19 Yes

3 No

I have a small PL/SQL Block assume in this way begin select * from emp where empno=100; except..

Answer / sdp

Yes , it will give an error as for single row queries we
need to include the into clause also
the query would be

declare
v_emp emp%rowtype%;
begin
select * into v_emp from emp where empno=100;
exception
---
---
end;

Is This Answer Correct ?

5 Yes

8 No

Post New Answer