OraFAQ Forum: JDeveloper, Java & XML » java.sql.SQLException: ORA-03120: two-task conversion routine: integer overflow

Home » Developer & Programmer » JDeveloper, Java & XML » java.sql.SQLException: ORA-03120: two-task conversion routine: integer overflow

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

java.sql.SQLException: ORA-03120: two-task conversion routine: integer overflow [message #91606]

Fri, 06 December 2002 14:31

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

Report message to a moderator

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

Mahesh Rajendran
Messages: 10708
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.

Report message to a moderator

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

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

Report message to a moderator

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

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

Report message to a moderator

Previous Topic:	Problems with loadjava
Next Topic:	How to relocate buttons on standard OA page

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 28 16:19:29 CST 2024