Question

how can i resolve oracle error 00103

PL/SQL, Oracle error messages, Oracle 9i, ORA-00103

I am getting the following error when running the below procedure from TOAD. I have ora 9i OS Windoes XP.

CREATE OR REPLACE PROCEDURE SP_CALL_PROCEDURE22 (BUSINESS_UNIT1 in varchar2)
IS
CURSOR C1 IS
SELECT BUSINESS_UNIT,VOUCHER_ID,INVOICE_ID,VENDOR_ID,GROSS_AMT
FROM PS_VOUCHER
WHERE BUSINESS_UNIT= BUSINESS_UNIT1;
C C1%ROWTYPE;
BEGIN
FOR C IN C1 LOOP
BEGIN
INSERT INTO SYSADM.voucher_tmp values (C.BUSINESS_UNIT,C.VOUCHER_ID,C.INVOICE_ID);
COMMIT;
END LOOP;
END;

(14,4)ORACLE ERROR 00103.PLS-00103: Encountered the symbol ";" when expecting one of the following:loop

I am far from an expert in PL/SQL, but I believe you need to have an "END;" prior to the END LOOP: to match your Begin statement.

ie
COMMIT;
END;
END LOOP;
END;
/