Exception in component tDBOutput_1 (iteration_productmodel) java.sql.SQLSyntaxErrorException: ORA-01723: zero-length columns are not allowed
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:195) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1036) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1336) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1916) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1878) at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:318)
The ORA-01723: zero-length columns are not allowed will be created when you tried to create a table but you specified a column as either CHAR(0) or VARCHAR2(0).
In Talend Context, you must be using the option in the tDBOutput component to create a table or create a table if not exist or Drop and create a table. In this case, all the columns of character format will need some value in the length field (which is non zero).
Could you please provide this to all the columns in your schema and retry it?
If the answer has helped you, could you please mark the topic as resolved. Kudos are also welcome 🙂
