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(
at oracle.jdbc.driver.T4CTTIoer.processError(
at oracle.jdbc.driver.T4CTTIoer.processError(
at oracle.jdbc.driver.T4C8Oall.receive(
at oracle.jdbc.driver.T4CStatement.doOall8(
at oracle.jdbc.driver.T4CStatement.execute_for_describe(
at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(
at oracle.jdbc.driver.T4CStatement.execute_maybe_describe(
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(
at oracle.jdbc.driver.OracleStatement.executeQuery(
at btob.extractandload.ExtractAndLoad.tOracleInput_2Process(
at btob.extractandload.ExtractAndLoad.tOracleConnection_1Process(
at btob.extractandload.ExtractAndLoad.runJob(
at btob.extractandload.ExtractAndLoad.main(
Job ExtractAndLoad ended at 17:06 22/01/2008.
You will find my job design in attachment.
Thank You for your helpfull
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.