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

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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Why we use join in sql?

944


What are the different types of sql commands?

1109


What are different types of sql?

1159


What is a sql trace file?

1011


Can we delete column in sql?

1078


What are inner and outer joins examples of both?

940


What is forward declaration in pl sql?

1056


What are secondary keys?

957


What is the use of & in pl sql?

1031


What are different types of indexes?

996


How to display Row Number with Records in Oracle SQL Plus?

1026


How many joins in sql?

983


What is sql select statement?

1014


What is sqlservr exe?

965


What is a temporal table?

916