Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 17009 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
explain advantages of myisam over innodb? : Sql dba
How to execute a stored procedure?
Which data dictionary views have the information on the triggers that are available in the database?
What is mdb stand for?
how to get a list of all tables in a database? : Sql dba
Is sql dba a good career? : SQL DBA
What are the commands used in sql?
How do I run a pl sql program?
Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?
What are the uses of sysdate and user keywords?
What are the types of records?
what are the advantages of using stored procedures? : Sql dba
What is trigger and how to use it in sql?
What are three advantages to using sql?
What is clustered index sql?
