Issues with DB GroupBy and ORA-01722 Error in KNIME with Oracle DB

Hello,

I am attempting to execute a DB GroupBy operation on an Oracle database containing approximately 700 million records. However, the operation consistently fails. To address this, we are running the GroupBy in iterations. Each iteration is supposed to retrieve one record, but when I try to fetch the result using a DB Reader, it takes an excessively long time (over 5 minutes) and eventually throws the error:

ORA-01722: invalid number.

My main question is whether it is possible to directly write the output of the DB GroupBy to a table in the database without loading the data into KNIME memory via a DB Reader. I have not found a DB node that allows writing back to the database directly from the GroupBy output without first passing through KNIME’s memory.

Is there a way to achieve this? Any advice or alternative suggestions would be greatly appreciated.

Thank you!