Error from fileinputdelimited to toracleoutput

Six Stars

Error from fileinputdelimited to toracleoutput

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)

Employee

Re: Error from fileinputdelimited to toracleoutput

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

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Talend API Designer – Technical Overview

Take a look at this technical overview video of Talend API Designer

Watch Now

Talend Integration with Databricks

Take a look at this video about Talend Integration with Databricks

Watch Now

Getting Started with APIs

Find out how to get started with APIs

Read