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
- 17078 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
What is spool?
What is scalar and vector?
Explian rowid, rownum? What are the psoducolumns we have?
How do you declare a user-defined exception?
What is partition in sql query?
how to do backup entire database? : Transact sql
Can we use pl sql in sql server?
How do you sort in sql?
What is pragma in sql?
How many databases can sql express handle?
what are different types of collation sensitivity? : Sql dba
Mention what does plv msg allows you to do?
what is the use of double ampersand (&&) in sql queries?
Is sqlite good enough for production?
What is a column in a table?
