I have one oracle table and I created an other one with the same structure (both have one field of type BLOB) and I build the job which copies the first table into the second (OracleInput --------------> OracleOutput). but when I execute my job no data is inserted into my target table and the following error message is displayed:
Starting job test_blob_provincia at 12:11 14/11/2007.
Exception in component tOracleOutput_1
java.sql.SQLException: Tipo di colonna non valido
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:227)
at oracle.jdbc.driver.OracleStatement.get_internal_type(OracleStatement.java:3150)
at oracle.jdbc.driver.OraclePreparedStatement.setNullInternal(OraclePreparedStatement.java:3665)
at oracle.jdbc.driver.OraclePreparedStatement.setNull(OraclePreparedStatement.java:3653)
at caccia_project.test_blob_provincia.test_blob_provincia.tOracleInput_1Process(test_blob_provincia.java:386)
at caccia_project.test_blob_provincia.test_blob_provincia.main(test_blob_provincia.java:536)
Job test_blob_provincia ended at 12:11 14/11/2007.
Note: java.sql.SQLException: Tipo di colonna non valido = column type is not valid.
Any Help??
Thanks in advance!!
Sidi.
