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
Why we use join in sql?
What are the different types of sql commands?
What are different types of sql?
What is a sql trace file?
Can we delete column in sql?
What are inner and outer joins examples of both?
What is forward declaration in pl sql?
What are secondary keys?
What is the use of & in pl sql?
What are different types of indexes?
How to display Row Number with Records in Oracle SQL Plus?
How many joins in sql?
What is sql select statement?
What is sqlservr exe?
What is a temporal table?