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...

What is an Exception ? What are types of Exception ?

Answer Posted / tulsi

Exception is the error handling part of PL/SQL block. The
types are Predefined and user_defined. Some of Predefined
execptions are.
CURSOR_ALREADY_OPEN
DUP_VAL_ON_INDEX
NO_DATA_FOUND
TOO_MANY_ROWS
INVALID_CURSOR
INVALID_NUMBER
LOGON_DENIED
NOT_LOGGED_ON
PROGRAM-ERROR
STORAGE_ERROR
TIMEOUT_ON_RESOURCE
VALUE_ERROR
ZERO_DIVIDE
OTHERS.

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How is indexing done in search engines?

982


What is sql and db2?

1003


What is the difference between distinct and unique in sql?

946


What are the types of join and explain each?

1041


what is 'mysqlshow'? : Sql dba

1026


Why is sql better than hql?

991


Is sql scripting language?

1051


how to concatenate two character strings? : Sql dba

1100


What is out parameter used for eventhough return statement can also be used in pl/sql?

1077


What are the benefits of pl/sql packages?

1107


How do you define a foreign key?

1002


Why is normalization important?

1027


What will you get by the cursor attribute sql%rowcount?

1037


What are string functions in sql?

1240


what are different types of collation sensitivity? : Sql dba

1065