Is there a contradiction between this pasuk in Koheles and this Ben Ish Chai?

Koheles 9:5: “For the living know that they will die, but the dead know nothing, and they have no more reward, for their remembrance is forgotten.”

Ben Ish Chai (Rav P’alim Vol II YD 31): “נמצא לא הותר לאדם להתפלל על קברי הצדיקים, לשאול בקשתו מן הצדיקים עצמן, כי זה חשיב דורש אל המתים, אלא הוא מתפלל ושואל בקשתו מהקב”ה, ורק מבקש מנפש הצדיק שתתפלל עליו לפני הקדוש ברוך הוא, שישמע תפלתו ויעשה בקשתו”

Ive found out that a lot acharonim paskened against asking tzadikim for intercession, which surprises me because there’s a gemara in sotah that Kalev went to Machpelah to ask the avos for protection from the spies. And Iv’e read that there’s pesukim in Zohar that support this position as well.

But on the other hand Ive read that the Radak interpreted this Koheles to mean that it’s assur to ask for help from the dead, and that R. Yehuda ibn Bil’am wrote this in his commentary on Yeshayahu 8:19: “The soul has no knowledge after its separation from the body.”

So I don’t know what to make of this.

​