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;

What is out parameter used for eventhough return statement can also be used in pl/sql?

0 Answers  

---

what are date and time intervals? : Sql dba

0 Answers  

---

What are actual parameters and formal parameters?

0 Answers  

---

Which is faster view or stored procedure?

0 Answers  

---

what is query cache in mysql? : Sql dba

0 Answers  

---

Is foreign key mandatory?

0 Answers  

---

Does SQL*Plus contains pl/sql Engine?

1 Answers   TCS,

---

Can you have multiple SPs with the same name on a database?

2 Answers   CGI, Quest,

---

What is transaction control language (tcl)?

0 Answers  

---

what are myisam tables? : Sql dba

0 Answers  

---

write a query find which rows of a table is updated on 2 days before?

3 Answers   TCS,

---

What is the unique index?

0 Answers  

---