Simpler Navigation coming for Servers and Operating Systems
Coming soon: a much simpler Servers and Operating Systems section of the Community. We will combine many of the older boards, and you won't have to click through so many levels to get at the information you need. If you are looking for an older board and do not find it, check the consolidated boards, as the posts are still there.
cancel
Showing results for 
Search instead for 
Did you mean: 

ora-03120

jonax
Occasional Contributor

ora-03120

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?

thanks,


3 REPLIES
Indira Aramandla
Honored Contributor

Re: ora-03120

Ho jonax,

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.


IA

Never give up, Keep Trying
Sunil Kumar MK
Occasional Advisor

Re: ora-03120

Just to let you know:

You can get more information on errors by using the "oerr" utility:

Ex: If your error is ORA 3120 :

then at the Unix prompt type:
$> oerr ora 3120

Normaly you might get troubleshooting information as well.

Regards
Sunil
jonax
Occasional Contributor

Re: ora-03120

Thanks for helping me. Have a nice day.