Delimited txt file to Oracle Database

Anonymous — Sat, 16 Nov 2024 11:01:48 GMT

I am trying to take a delimited text file and load the data to an oracle table. However I am getting the following error:
Starting job Job2 at 00:16 27/09/2015.
[statistics] connecting to socket on port 4010
[statistics] connected
Load to Table
Exception in component tOracleOutputBulkExec_1_tOBE
java.sql.SQLSyntaxErrorException: ORA-01723: zero-length columns are not allowed
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:936)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1770)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1739)
at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:298)
at asd.job2_0_1.Job2.tFileInputDelimited_1Process(Job2.java:1134)
at asd.job2_0_1.Job2.tJava_1Process(Job2.java:444)
at asd.job2_0_1.Job2.runJobInTOS(Job2.java:1951)
at asd.job2_0_1.Job2.main(Job2.java:1795)
Exception in component tOracleOutputBulkExec_1_tOBE
java.sql.SQLSyntaxErrorException: ORA-01723: zero-length columns are not allowed
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:936)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1770)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1739)
at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:298)
at asd.job2_0_1.Job2.tFileInputDelimited_1Process(Job2.java:1134)
at asd.job2_0_1.Job2.tLibraryLoad_1Process(Job2.java:1605)
at asd.job2_0_1.Job2.tLibraryLoad_2Process(Job2.java:1717)
at asd.job2_0_1.Job2.runJobInTOS(Job2.java:1963)
at asd.job2_0_1.Job2.main(Job2.java:1795)
[statistics] disconnected
Job Job2 ended at 00:16 27/09/2015. [exit code=1]
The only thing I can assume is that the oracleoutputbulkexec isn't reading the input file, even though I gave the correct path.
The tjava just contains: a print statement.
The two library loads contain oracle jars 6 and 7.
Any help is appreciated. Thank You

Re: Delimited txt file to Oracle Database

Anonymous — Mon, 28 Sep 2015 09:25:34 GMT

Does the table already exist or it is created on tOracleOutputBulkExec_1_tOBE? If latter, make sure the length of columns is defined on the schema.

[font=Verdana, Helvetica, Arial, sans-serif] Best regards[/font]
[font=Verdana, Helvetica, Arial, sans-serif] Shong[/font]

topic Delimited txt file to Oracle Database in Talend Studio

Delimited txt file to Oracle Database

Re: Delimited txt file to Oracle Database