While inserting 10 rows using procedure, if 3rd entry is
having some error, what will be the output? How u will
handle that error?
Answer Posted / vaibhavi_dixit
When an exception is raised, oracle searches for the
handler in the PL/SQL block, if not then the exception is
propagated to the outer block.If the outer block handles
the exception, then the statments are commited (i.e 1 & 2),
the error message will be displayed and the control will
return to calling environment.
If the exception remains unhandled in all blocks ,then
before control returning to the calling environment,
statements i.e (1 & 2) will be rolled back.
VD
Is This Answer Correct ? | 13 Yes | 2 No |
Post New Answer View All Answers
Does sql profiler affect performance?
What are dml commands?
What is set serveroutput on in pl sql?
how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc
What is sql analyzer?
What is the difference between function and procedure in pl/sql?
What are some predefined exceptions in pl/sql?
explain primary keys and auto increment fields in mysql : sql dba
How do I install microsoft sql?
Do foreign keys improve performance?
What is schema in sql?
Mention what are different methods to trace the pl/sql code?
What does pragma mean?
Why trigger is used in sql?
How does stored procedure reduce network traffic?