Answer / madhuri

Execution is exception is done in many ways.

An exception occurs when there is something wrong in the
code of pl/sql block.
Exception can be raised either in declarative,executable or
in exception section itself.
In case of nested blocks when an exception occurs in inner
block,it will try to find its handle in the same block,if
not then control comes out of inner block and executes the
handler in the outer block.

When exception occurs in declarative and exception
section,then control is propagated to the next outer block.

Answer / swapna

We use exceptions to check the status of our procs .. like
what to do if the things are not going smoothly as
expected . ie we insert errors in audit tables with
user,date-time,err code.

Can we use SQL%ISOPEN in implicit cursors? Does this attribute works properly in Implicit Curosors?

3 Answers  

---

can i call procedure in package

3 Answers   TCS,

---

what is ref cursor in pl/sql?

3 Answers  

---

What are string functions in sql?

0 Answers  

---

How many sql are there?

0 Answers  

---

Enlist the characteristics of pl/sql?

0 Answers  

---

What is optimistic concurrency control? : Transact sql

0 Answers  

---

what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba

0 Answers  

---

What is INSTEAD OF trigger ?

13 Answers   Hexaware, TCS,

---

Is foreign key mandatory?

0 Answers  

---

Do we need commit after truncate?

0 Answers  

---

When should I use nosql database?

0 Answers  

---