I need a exceptoin in pl/sql block so that if any errors
occur in the block then no exception should errors should
raise?
- 1 Answers
- 4570 Views
- I also Faced
- E-Mail Answers
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
How to select all records from the table?
What is synonyms?
What has stored procedures in sql and how we can use it?
What are schema-level triggers?
What is record data type?
How many disk partitions should I have?
What is sql clause?
Is left join and outer join same?
How can you view the errors encountered in a trigger?
What is a left join?
Which join is like inner join?
Does pl sql work in mysql?
How can you save or place your msg in a table?
What is the cause of mutating table error and how can we solve it?
Can %notfound return null after a fetch?
