topic Re: Exception in component tOracleInput in Talend Studio https://community.qlik.com/t5/Talend-Studio/Exception-in-component-tOracleInput/m-p/2206286#M6409 It's OK, I think I have found my error :<BR />At the end of my SQL queries I put this following character ";", which raise the error. Tue, 22 Jan 2008 16:27:28 GMT Anonymous 2008-01-22T16:27:28Z Exception in component tOracleInput https://community.qlik.com/t5/Talend-Studio/Exception-in-component-tOracleInput/m-p/2206285#M6408 Hi everybody, <BR />I get this following exception when using the tOracleInput component and i don't understand what it means : <BR />Starting job ExtractAndLoad at 17:06 22/01/2008. <BR />Exception in component tOracleInput_2 <BR />java.sql.SQLException: ORA-00911: invalid character <BR /> at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125) <BR /> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305) <BR /> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272) <BR /> at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623) <BR /> at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:112) <BR /> at oracle.jdbc.driver.T4CStatement.execute_for_describe(T4CStatement.java:351) <BR /> at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:896) <BR /> at oracle.jdbc.driver.T4CStatement.execute_maybe_describe(T4CStatement.java:383) <BR /> at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:986) <BR /> at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1125) <BR /> at btob.extractandload.ExtractAndLoad.tOracleInput_2Process(ExtractAndLoad.java:267) <BR /> at btob.extractandload.ExtractAndLoad.tOracleConnection_1Process(ExtractAndLoad.java:166) <BR /> at btob.extractandload.ExtractAndLoad.runJob(ExtractAndLoad.java:559) <BR /> at btob.extractandload.ExtractAndLoad.main(ExtractAndLoad.java:493) <BR />Job ExtractAndLoad ended at 17:06 22/01/2008. <BR />You will find my job design in attachment. <BR />Thank You for your helpfull Sat, 16 Nov 2024 14:28:35 GMT https://community.qlik.com/t5/Talend-Studio/Exception-in-component-tOracleInput/m-p/2206285#M6408 Anonymous 2024-11-16T14:28:35Z Re: Exception in component tOracleInput https://community.qlik.com/t5/Talend-Studio/Exception-in-component-tOracleInput/m-p/2206286#M6409 It's OK, I think I have found my error :<BR />At the end of my SQL queries I put this following character ";", which raise the error. Tue, 22 Jan 2008 16:27:28 GMT https://community.qlik.com/t5/Talend-Studio/Exception-in-component-tOracleInput/m-p/2206286#M6409 Anonymous 2008-01-22T16:27:28Z