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
- 3 Answers
- 8129 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Can you load data into multiple tables at once? : aql loader
What is rowid in sql?
What is cross join sql?
What is inner join in sql?
What is offset and limit in sql?
Is t sql a programming language?
how to increment dates by 1 in mysql? : Sql dba
What is int identity in sql?
What type of database is cloud sql?
What problem one might face while writing log information to a data-base table in pl/sql?
What is a sql schema used for?
What does select * from mean in sql?
What if we write return in procedure?
What is sql profiling in oracle?
What is field delimiter?
