Divided by 0 exception error?

Question

We created a procedure, where there is a formula as follows.

Count:=Avl/cnter

Here some times the cnter value is coming 0. So the procedure is throughing an exception. How can we handle this error in pl/sql procedure?

Answer 1

0

You could avoid the error altogether, don't divide when 0, just return a 0 (or some other value):

count = case when cntr <> 0 then avl/cntr else 0 end

answered Dec 10 '09 at 02:33 AM

KillerDBA
1.5k ● 5 ● 9 ● 10

Yep KillerDBA. This case statement solved the eror. Thank you.

Dec 10 '09 at 09:19 PM dbkid

(comments are locked)