Error from fileinputdelimited to toracleoutput

mahesh_Dev — Sat, 16 Nov 2024 07:29:39 GMT

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)

Re: Error from fileinputdelimited to toracleoutput

Anonymous — Wed, 10 Oct 2018 05:14:57 GMT

Hi,

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 🙂

Warm Regards,

Nikhil Thampi

topic Re: Error from fileinputdelimited to toracleoutput in Talend Studio

Error from fileinputdelimited to toracleoutput

Re: Error from fileinputdelimited to toracleoutput