 Posted 6/14/2010 12:03:07 PM
|
|
|
|
| ORA-03120 two-task conversion routine: integer overflow ORA-03120 two-task conversion routine: integer overflow
Cause: An integer value in an internal Oracle structure overflowed when being sent or received over a heterogeneous connection. This can happen when an invalid buffer length or too great a row count is specified. It usually indicates a bug in the user application.
Action: Check parameters to Oracle calls. If the problem recurs, reduce all integer parameters, column values not included, to less than 32767.
|
|
|
Posted 6/14/2010 12:03:31 PM
|
|
|
|
This ora error ora-03120 happens because pl/sqsl limitations on the varchar2* is 32767, and it uses that internally to hold the information on oracle calls.
so if you exceed it, you'll get that error.
it's not common to receive that, in fact it's very rare.
as the message points out it's attributed 100% to poor programming of PL\Sql and/or a bug within the app calling Oracle.
you should perform a code review of the suspect area and determine whether you are calling Oracle in the best way, whether any of your queries are faulty, and whether there are any known bugs in your abstraction layer (if you have one).
|
|
|
Posted 6/14/2010 12:04:00 PM
|
|
|
|
Hi everyone,
Please help me on how to provide work around solutions with the error that i've encountered with my db.
Below is the error produced.
Error: ORA 3120 two-task conversion routine: integer overflow
The said error encountered while running forms application.
oracle ver: 8.1.6.3
forms ver: 6
os ver : solaris 5.8
Does anyone know how?
|
|
|
Posted 6/14/2010 12:04:23 PM
|
|
|
|
Error: ORA 3120 "Two-task conversion routine: integer overflow". This error may be the cause due to the following.
May be an integer value in an internal Oracle structure overflowed when being sent or received over a heterogeneous connection. This can happen when an invalid buffer length or too great a row count is specified.
For this check parameters to Oracle calls. If the problem recurs, reduce all integer parameters, column values to less than 32767.
Or it could be due to a BUG in Oracle Server - Enterprise Edition 8.1.6, with Oracle Developer 6.0.8 when selecting ROWID gives the error due to a BUG 1420237.
Enterprise Edition 8.1.6 fact: Required Support Files (RSF) 8.0.6. A fix for this would be to apply Developer 6i patch 6, which includes RSF 8.0.6.3.
Or when you create a stored procedure in report in program unit and when calling the procedure it may produce the error. For this the fix would be save the procedure in database and call it from report, without including it on client side.
|
|
|
Posted 6/14/2010 12:05:48 PM
|
|
|
|
ORA-03120 / ORA-03106 can occur when a 9.0 client SELECTs a CLOB from a 9.2 (or higher) database where the client and server have differing character sets.
eg; 9.0 client with WE8ISO8859P1 to 9.2 DB with UTF8 character set may fail with ORA-3106
another cause could be a bug in the Oracle RDBMS 9.2 internal codeset.
|
|
|
|