[Error] Compilation (533: 5): PLS-00103: Encountered the symbol "end-of-file" when expecting one of
PROCEDURE GetDistinctCustomers
AS
CURSOR customer_cursor IS
SELECT DISTINCT WHSE_NUMBER, SHORT_BASE_NAME, CUSTOMER_NAME
FROM afsv.afsv_pv_mtf
WHERE CUSTOMER_NAME NOT IN
(SELECT CUSTOMER_NAME FROM afsv.afsv_pv_contact);
v_whse_number afsv.afsv_pv_mtf.WHSE_NUMBER%TYPE;
v_short_base_name afsv.afsv_pv_mtf.SHORT_BASE_NAME%TYPE;
v_customer_name afsv.afsv_pv_mtf.CUSTOMER_NAME%TYPE;
v_count NUMBER;
BEGIN
FOR rec IN customer_cursor
LOOP
SELECT COUNT (*)
INTO v_count
FROM afsv.afsv_pv_mtf
WHERE WHSE_NUMBER = rec.WHSE_NUMBER
AND SHORT_BASE_NAME = rec.SHORT_BASE_NAME
0