Home » Developer & Programmer » JDeveloper, Java & XML » java.sql.SQLException: ORA-03120: two-task conversion routine: integer overflow
java.sql.SQLException: ORA-03120: two-task conversion routine: integer overflow [message #91606] Fri, 06 December 2002 14:31 Go to next message
Doug Campbell
Messages: 2
Registered: December 2002
Junior Member
Environment is Oracle9.2/W2K with oracle9 jdbc drivers.

Executing preparedStatment.setCharacterStream(int i, Reader, int length) throws this stackTrace

---- code
stmt.setCharacterStream(1, reader, data.length());
stmt.setDate(2, date); // recd time
stmt.setInt(3, INBOUND);
stmt.setNull(4, Types.CLOB);
stmt.setCharacterStream(4, reader2, reply.length);
stmt.setInt(5, NEW_STAT); // process stat
stmt.setInt(6, 0); // RETRY COUNT
stmt.setInt(7, RETRY_MAX); // retry max
-- end code

java.sql.SQLException: ORA-03120: two-task conversion routine: integer overflow
[[13:03:00,864,Default]] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
[[13:03:00,864,Default]]
[[13:03:00,864,Default]] at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
[[13:03:00,864,Default]]
[[13:03:00,864,Default]] at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
[[13:03:00,864,Default]]
[[13:03:00,864,Default]] at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
[[13:03:00,864,Default]]
[[13:03:00,864,Default]] at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1093)
[[13:03:00,874,Default]]
[[13:03:00,874,Default]] at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2047)
[[13:03:00,874,Default]]
[[13:03:00,874,Default]] at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1940)
[[13:03:00,874,Default]]
[[13:03:00,874,Default]] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2709)
[[13:03:00,874,Default]]
[[13:03:00,874,Default]] at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:589)
[[13:03:00,874,Default]]
[[13:03:00,874,Default]] at org.jboss.pool.jdbc.PreparedStatementInPool.executeUpdate(Unknown Source)

Anybody come up against this?

The column type is long which the character stream is being set on
Re: java.sql.SQLException: ORA-03120: two-task conversion routine: integer overflow [message #91613 is a reply to message #91606] Mon, 09 December 2002 07:01 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
1. Is any pl/sql table involved?
2. Check parameters to Oracle calls.
If the problem recurs, reduce all integer parameters,
column values to less than 32767.
Re: java.sql.SQLException: ORA-03120: two-task conversion routine: integer overflow [message #91822 is a reply to message #91613] Thu, 06 March 2003 16:59 Go to previous messageGo to next message
Mike Young
Messages: 1
Registered: March 2003
Junior Member
We get this same error when inserting into one table using a select from an external joined table. Since the source and target tables have the exact same definition it is not do to an integer value being too large in the table. Any help is greatly appreciated
Re: java.sql.SQLException: ORA-03120: two-task conversion routine: integer overflow [message #192481 is a reply to message #91822] Tue, 12 September 2006 09:53 Go to previous message
baskaranprasad
Messages: 13
Registered: August 2006
Location: Bangalore
Junior Member
Please check is there any LOB columns are involved in the hetrogenious schemas.CLOB/BLOB/LONG RAW values can not be transfered thru DB Link.Try with OCI or Pro*C
Previous Topic: Problems with loadjava
Next Topic: How to relocate buttons on standard OA page
Goto Forum:
  


Current Time: Sat Dec 03 14:14:39 CST 2016

Total time taken to generate the page: 0.04981 seconds