One Star

Exception in component tOracleInput

Hi everybody,
I get this following exception when using the tOracleInput component and i don't understand what it means :
Starting job ExtractAndLoad at 17:06 22/01/2008.
Exception in component tOracleInput_2
java.sql.SQLException: ORA-00911: invalid character
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:112)
at oracle.jdbc.driver.T4CStatement.execute_for_describe(T4CStatement.java:351)
at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:896)
at oracle.jdbc.driver.T4CStatement.execute_maybe_describe(T4CStatement.java:383)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:986)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1125)
at btob.extractandload.ExtractAndLoad.tOracleInput_2Process(ExtractAndLoad.java:267)
at btob.extractandload.ExtractAndLoad.tOracleConnection_1Process(ExtractAndLoad.java:166)
at btob.extractandload.ExtractAndLoad.runJob(ExtractAndLoad.java:559)
at btob.extractandload.ExtractAndLoad.main(ExtractAndLoad.java:493)
Job ExtractAndLoad ended at 17:06 22/01/2008.
You will find my job design in attachment.
Thank You for your helpfull
1 REPLY
One Star

Re: Exception in component tOracleInput

It's OK, I think I have found my error :
At the end of my SQL queries I put this following character ";", which raise the error.