Database connection table writer

KNIME Analytics Platform
1

Hi,

The Database connection table writer raise this error:

ERROR Database Connection Table Writer Execute failed: ORA-00907: missing closed parenthesis

The only parameter is the name movim_2015 without blank or dirty characters.

The same table with a database writer works correctly.

Which is the condition that raises this error?

Thanks

2

What's the SQL query from the previous node? You can see it in the output port view. What happens if you use the Database Connection Reader?

3

The SQL query works correctly and the number of open parenthesis is equal to the number of closed parenthesis.

The couple of Database connection table reader + Database Writer works fine

4

The Database Connection Table Writer issues the following statement:

CREATE TABLE <tableName> AS (<query>)

I have no idea why Oracle doesn't like it. Is the <query> very long so that probably a size limit is reached?

5

I have found the problem!

i must remove the order by from the query

I think that it is a bug...

1 Like
6

If so, then it's a bug in Oracle...