0 votes
in Oracle by
Q. How to handle errors in PL/SQL?

1 Answer

0 votes
by

In PL/SQL, an error condition is called an exception and PL/SQL errors are handled using the EXCEPTION block. The syntax for handling exceptions is written below:
DECLARE
...
BEGIN
...
EXCEPTION
WHEN exception1 THEN
...
WHEN exception2 THEN
...
WHEN others THEN
...
END;

Related questions

0 votes
asked Jul 29, 2020 in Oracle by Hodge
+1 vote
asked Mar 7, 2021 in PL/SQL by SakshiSharma
0 votes
asked Jul 29, 2020 in Oracle by Hodge
...