Answer / suresh kumar somayajula

Raising an error in PL/SQL execution block is nothing
but "Execption". These are of 2 types.
1.Predefined Exception 2. User defined Exception

Total 19+1 predefined exceptions are there.
19+1 means 19+When Others.
"When others" is the last one.After "When Others" no
exception will be raised.
Eg. for Predefined Exceptions:
No_data_found,Dup_val_on_index,Invalid_cursor,Invalid_number
,Zero_Divide,.......,'When Others'..

Thank you,
Suresh.

Answer / bala

Scope of exception in plsql is handled by Exception Block..
this is depends on the code you had written.
suppose u have created one more plsql block inside a plssql
block,if the inner block is not handled any exception then
the outer block will handle the exception by defining the
situation/even like "when others then / when value_error
then... etc "

Note.. when u r using "when Others then" all the exceptions
will handle by this exception.. Even there is no error the
plsql will return 0 for this exception that is executed by
default in a plsql block. So. be carefull while writting
this kind of exception ("When others then")

Answer / guest

to throw errors even when we wrongly tped

Answer / shanmukha srinivas

scope of exception (importance of exception)
exceptions r run time errors
in real time every procedures,functions used exception section at the end of program
because its gives which line get error comes, which error is coming by using error log table.

How do you rename a table in sql?

0 Answers  

---

what is meant by tuning and tk proof?

2 Answers  

---

What is the difference between an inner join and an outer join?

0 Answers  

---

What is the least restrictive isolation level? : Transact sql

0 Answers  

---

Write a query to find second highest salary of an employee.

27 Answers  

---

What is execute immediate?

0 Answers  

---

Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com

0 Answers   TCS,

---

What operators deal with null?

0 Answers  

---

What is use of trigger?

0 Answers  

---

What is meant by Materialized view?

2 Answers   iGate, Marlabs, Polaris,

---

How many sql databases can you have on one server?

0 Answers  

---

Can we write dml inside a function in sql server?

0 Answers  

---