Solved! Go to Solution.
Exception in component tOracleInput_1
java.sql.SQLException: Fonction non prise en charge
In the oracle Input When the schema matches the query there is an error on it :
But when the query provide much colomns than the query there is not an error, the rows are transmitted
in the output but no rows are inserted in the database table....
I think that there is no Oracle BLOB support in Talend...Maybe I miss something
Please upload a screenshot of schema of tOracleInput and show us your query, the problem occurs on tOracleInput component.
Do you use tOracleConnection to create a db connection or create the db connection on tOracleOutput?
I use tOracleConnection to create a db connection
If you use tOracleConnection in the job, you should use a tOracleCommit to commit the changes and close the connection