Oracle ORA-01722 error during a simple query

Hi all,

we are trying a simple query against an Oracle table, which just selects the whole table by a table selector node. Any tries to get data from this node lead to an error like:

”Error during fetching data from the database: java.sql.SQLSyntaxErrorException: ORA-01722: invalid number”. We tried all fields or single fields and got always the same result. The data types on the oracle side are varchar2 and binary_double.

When we tried exactly the same query which KNIME produces:

select \* “<schema name>”.”<table name>”

in Oracle SQL Developer everything worked fine and data was passed back.

So I wonder which SQL is passed against Oracle and how we can debug this case. Could it also be a bug?

Thanks in advance for any help