Проблемы с созданием процедуры

CREATE OR REPLACE PROCEDURE LAB4proc(dname IN detail.name%TYPE) IS
    
    customer INT;
    
    CURSOR get_detail(dname detail.name%TYPE) IS
                SELECT d.detail_key,d.name,SUM(t.VALUES_MANUFACTURES) AS valuee
                FROM detail d join TM t ON
                d.detail_key=t.detail_key join orders o ON o.order_key=t.order_key
                WHERE name = dname 
                GROUP BY d.detail_key,d.name;
                
            
BEGIN
 
                SELECT t.detail_key INTO customer
                FROM TM t join orders o ON t.order_key=o.order_key 
                WHERE order_date BETWEEN '01.01.2019' AND '12.31.2019';
 
        FOR in_det IN get_detail(dname)
        LOOP
        IF in_det.detail_key = customer THEN
          DBMS_OUTPUT.put_line(in_det.name ||' общее количество - '|| TO_CHAR(in_det.valuee));
           -- DELETE FROM detail WHERE detail_key = in_det.detail_key;
      END IF;
   
     END LOOP;
     
END;