Hello, all.

I have a procedure in which I'm using user-defined exception handling.
Below is the code:

-------------------------------------------------------------------
CREATE OR REPLACE PROCEDURE xxxx.PROC_REORG_TABLE
AS
BAD_COL EXCEPTION;
NO_EXIST EXCEPTION;
NO_SPACE EXCEPTION;

BEGIN
FOR get_reorg_table_name IN .....
LOOP
.....
IF V_IFEXISTS = 0 then
RAISE NO_EXIST;
END IF;
......
IF V_BADEXISTS > 0 THEN
RAISE BAD_COL;
END IF;
......
IF V_SIZE > V_SPACE THEN
RAISE NO_SPACE;
END IF;
..........
EXCEPTION
WHEN NO_EXIST THEN
update xxxx.xxxx_reorg_tables
........

WHEN NO_SPACE THEN
update xxxx.xxxx_reorg_tables
......

WHEN BAD_COL THEN
update xxxx.xxxx_reorg_tables
......

WHEN OTHERS THEN
update xxxx.xxxx_reorg_tables
.......
END:
END LOOP;
END;
-------------------------------------------------

The error I'm receiving is:

PLS-00103: Encountered the symbol "EXCEPTION"

Any help would be greatly appreciated.

Thanks in advance!

Jeff
PROTECTED COMMUNICATION (Privileged, Confidential, Copyrighted and/or Proprietary)
This communication and any of its attachments may contain privileged or confidential
information protected by legal rules or copyrighted or proprietary materials of
Handleman Company and/or its affiliates protected by law. It is solely for the use
of the intended recipient(s) named above. Any review, dissemination, distribution,
forwarding, or copying of this communication or associated attachments,
or the taking of any action based on it, by someone other than the intended recipient,
or the employee responsible for delivering this communication to the intended recipient,
is prohibited. If you have received this communication in error reply to the sender
via email, then permanently delete the original message and associated attachments
and destroy any copies or printouts.
Thank you.

Oracle LazyDBA home page