Invalid conversion requested with native oracle SQL query and date parameters

I think you are tryng convert a date type to date. If you remove this to_date function and just leave {{dateTo}} and {{dateFrom}}, it’s works?

that quotes around variable it’s strange too. Meabe need remove