Problem with un CLOB oracle

One Star

Problem with un CLOB oracle

Bonjour,
Dans un processus simple (Oracle Input - Map - Oracle Output) j'ai un soucis avec une colonne de type CLOB au niveau de l'output. En effet, le type est bien lu et interprété lors de l'input mais lorsqu'il doit être inséré par le biais du composant Oracle Output, j'ai une erreur qui est la suivante.
ORA-00942: table or view does not exist
Exception in component tOracleOutput_1
java.sql.SQLException: Type de colonne non valide
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 eworkarchiver.copy_of_testreaddata.Copy_of_TestReadData.tOracleInput_1Process(Copy_of_TestReadData.java:1061)
at eworkarchiver.copy_of_testreaddata.Copy_of_TestReadData.runJob(Copy_of_TestReadData.java:1267)
at eworkarchiver.copy_of_testreaddata.Copy_of_TestReadData.main(Copy_of_TestReadData.java:1211)

Est-ce un probleme de type au niveau du code généré? Aucune idée... mais visiblement le ce n'est pas le type Oracle qui est utilisé.
J'ai besoin d'une réponse rapide! Merci d'avance.
Juan
Community Manager

Re: Problem with un CLOB oracle

Hi Juan,
First, if you needed an "urgent" reply, you should have posted in English first place... I hope you will in the future...
Second, the use of "urgent" word in a post will not place your topic on the top of the stack... we just always do our best to help you as quickly as we possibly can...
We'll try to answer asap the following topic, 1366].

Hi,
In a simple process (Oracle Input - Map - Oracle Output) I encounter an issue with a CLOB type column at the output level. Indeed, the type is read and interpreted at Input level, but when it needs to be inserted via the Oracle Output component, I get an error as follows:
ORA-00942: table or view does not exist
Exception in component tOracleOutput_1
java.sql.SQLException: Type de colonne non valide
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 eworkarchiver.copy_of_testreaddata.Copy_of_TestReadData.tOracleInput_1Process(Copy_of_TestReadData.java:1061)
at eworkarchiver.copy_of_testreaddata.Copy_of_TestReadData.runJob(Copy_of_TestReadData.java:1267)
at eworkarchiver.copy_of_testreaddata.Copy_of_TestReadData.main(Copy_of_TestReadData.java:1211)

Could it be a type problem in the generated code? I've no clue... but obviously this is not the Oracle type that is used.
I need a reply urgently! Thanks in advance.
Juan

We'll try to answer asap the following related topic: 1366].