Delimited txt file to Oracle Database

[Anonymous]

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
                                                                                                                            

[Anonymous]

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]