Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


scope of exception handling in plsql

Answers were Sorted based on User's Feedback



scope of exception handling in plsql..

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.

Is This Answer Correct ?    8 Yes 2 No

scope of exception handling in plsql..

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")

Is This Answer Correct ?    4 Yes 4 No

scope of exception handling in plsql..

Answer / guest

to throw errors even when we wrongly tped

Is This Answer Correct ?    1 Yes 1 No

scope of exception handling in plsql..

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.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

what is a database lock ? : Sql dba

0 Answers  


What is a primary key, and how is it different from a unique key?

3 Answers  


Can I create table without primary key?

0 Answers  


Where is sql database stored?

0 Answers  


How do you update a value in sql?

0 Answers  


Why is normalization important?

0 Answers  


Is inner join same as self join?

0 Answers  


What is sqlite used for?

0 Answers  


Whate is use of MOD function in pl/sql.

3 Answers   Oracle,


What is anonymous block in sql?

0 Answers  


what is clause? : Sql dba

0 Answers  


How to look at the current sql*plus system settings?

0 Answers  


Categories