While inserting 10 rows using procedure, if 3rd entry is
having some error, what will be the output? How u will
handle that error?
- 8 Answers
- 15712 Views
- iFlex, I also Faced
- E-Mail Answers
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
Cite the differences between execution of triggers and stored procedures?
how to create a new table by selecting rows from another table in mysql? : Sql dba
What do you mean by table in sql?
What is the importance of sqlcode and sqlerrm?
How do you run a query?
What is mdf ldf and ndf?
How do I remove sql plus from windows 10?
What is online transaction processing (oltp)?
What is natural join in sql?
Is join and inner join the same?
Explain two easy sql optimizations.
Can you have a foreign key without a primary key?
How many scalar data types are supported in pl/sql?
How do you truncate?
Can we write dml inside a function in sql server?
