GoldenGate - PLW-06009: procedure "XXX" OTHERS handler does not end in RAISE or RAISE_APPLICATION_ERROR
I was in the middle of configuring OGG for a client and came across an issue when getting to the portion of installing support for sequences. This script creates some procedures to be used by OGG processes. I hope this helps someone as it took me some digging around to figure this one out. Enjoy! SQL> @sequence Please enter the name of a schema for the GoldenGate database objects: GGADMIN Setting schema name to GGADMIN SP2-0804: Procedure created with compilation warnings SP2-0804: Procedure created with compilation warnings UPDATE_SEQUENCE STATUS: Line/pos Error ---------- ----------------------------------------------------------------- 58/14 PLW-06009: procedure "UPDATESEQUENCE" OTHERS handler does not end in RAISE or RAISE_APPLICATION_ERROR GETSEQFLUSH Line/pos Error ---------- --------------------...