RosettaCodeData/Task/Detect-division-by-zero/PL-SQL/detect-division-by-zero-1.sql

12 lines
185 B
MySQL
Raw Permalink Normal View History

2013-04-10 22:43:41 -07:00
FUNCTION divide(n1 IN NUMBER, n2 IN NUMBER)
RETURN BOOLEAN
IS
result NUMBER;
BEGIN
result := n1/n2;
RETURN(FALSE);
EXCEPTION
WHEN ZERO_DIVIDE THEN
RETURN(true);
end divide;