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
- 4944 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
What is gpt format?
what are the authentication modes in sql server? : Sql dba
what are the differences among rownum, rank and dense_rank? : Sql dba
how to use in conditions? : Sql dba
What is dml statement?
How many sql commands are there?
What is hibernate and its relation to sql?
What is cost in sql execution plan?
how to analyze tables with 'mysqlcheck'? : Sql dba
How do I remove all records from a table?
what is the use of set statement in tsql? : Transact sql
What is nvarchar max in sql?
What are aggregate and scalar functions?
What will you get by the cursor attribute sql%found?
What is the syntax to add a record to a table?
