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;

Do prepared statements prevent sql injection?

0 Answers  

---

How do you update a value in sql?

0 Answers  

---

What are reports usually used for?

0 Answers  

---

How to avoid using cursors?

0 Answers  

---

Can procedure in package be overloaded?

0 Answers   EXL,

---

What are the benefits of pl sql?

0 Answers  

---

how can i read files from a pl/sq l program

3 Answers  

---

When is the update_statistics command used?

0 Answers  

---

Is sql easier than java?

0 Answers  

---

What is difference between cursor and trigger?

0 Answers  

---

What are the advantages of the packages

6 Answers   Oracle,

---

what are the drivers in mysql? : Sql dba

0 Answers  

---