CREATE OR REPLACE PACKAGE BODY pkgDynamicSQL AS
    FUNCTION getClientMaxBuyProduct(g_member_id NUMBER) RETURN VARCHAR IS
    
    pname VARCHAR(50);
    dynamicsql VARCHAR2(500);
    
    BEGIN
        
        dynamicsql := 'SELECT productname FROM(SELECT p.productname FROM cart c
            INNER JOIN Member m ON c.member_id = m.member_id
            INNER JOIN Product p ON c.product_id = p.product_id
            AND c.quantity = (SELECT MAX(quantity) FROM cart WHERE member_id =  :member_id)
            AND m.member_id = :member_id
            GROUP BY p.productname, c.quantity)
            WHERE ROWNUM = 1';
            EXECUTE IMMEDIATE dynamicsql INTO pname USING g_member_id;
    RETURN pname;
    END;
    
END pkgDynamicSQL;

declare 
a varchar(50);
begin
    a := pkgDynamicSQL.getClientMaxBuyProduct(5);
    dbms_output.put_line(a);
end;

Error starting at line : 26 in command -
declare 
a varchar(50);
begin
    a := pkgDynamicSQL.getClientMaxBuyProduct(5);
    dbms_output.put_line(a);
end;
Error report -
ORA-01008: не все переменные привязаны
ORA-06512: на  "STORE.PKGDYNAMICSQL", line 16
ORA-06512: на  line 4
01008. 00000 -  "not all variables bound"