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

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

I need a exceptoin in pl/sql block so that if any errors
occur in the block then no exception should errors should
raise?

Question Posted / rajudatla


I need a exceptoin in pl/sql block so that if any errors occur in the block then no exception shou..

Answer / joseph p v

I think your question is as follows.
I need an exception in pl/sql block so that if any errors
occur in the block then no exception should raise?

For that see the below code part :-

exception
when others then
null;

--Example
declare
cha char(5):='TEST';
num number;
begin
num := cha;
exception
when others then null;
end;

Is This Answer Correct ?    5 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What is procedure in pl sql?

0 Answers  

Talk about views

10 Answers   Polaris,

What does pl sql developer do?

0 Answers  

If a procedure within a package is invalidated whether the entire package will be invalid and has to be recompiled again?

2 Answers   IBM, TCS,

What is a scalar value in sql?

0 Answers  

how many ways to get the current time? : Sql dba

0 Answers  

how to use in conditions? : Sql dba

0 Answers  

how to retrieve the top 2 salaried persons from a database?

7 Answers   Orion Laboratories,

What sql does db2 use?

0 Answers  

Types of backups ?

3 Answers   TCS,

What is materialised View?

2 Answers   IBM,

What is scalar data type in pl sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories