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)
CURSOR C1 IS
WHERE BUSINESS_UNIT= BUSINESS_UNIT1;
FOR C IN C1 LOOP
INSERT INTO SYSADM.voucher_tmp values (C.BUSINESS_UNIT,C.VOUCHER_ID,C.INVOICE_ID);
(14,4)ORACLE ERROR 00103.PLS-00103: Encountered the symbol ";" when expecting one of the following:loop
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!