Re: How to determine if a relink is necessary?

  • From: "Ethan Post" <post.ethan@xxxxxxxxx>
  • To: "Goulet, Richard" <Richard.Goulet@xxxxxxxxxxx>
  • Date: Wed, 19 Nov 2008 11:14:36 -0600

The error is period/random, does not occur every time.

OCI0000178 - Unable to execute - SQL STATEMENT HERE...

OCI0000179 - Error - ORA-03120: two-task conversion routine: integer
overflow

The SQL is using binds. My guess is that the client side is putting together
a variable like 99999 and in the course of passing it off to Oracle it is
coming across as 99999.000000000000000000 or something, or perhaps it is
somehow coming back to the client like that. I saw this with Powerbuilder
when we went to 10G, Oracle could no longer recognize a CHR(1) coming from
Oracle and changed everything to CHR(2000), when this came back to the
client and then was used in another call to Oracle the call would fail
becuase of 999 padded blanks. In our case I believe we had to update the
Powerbuilder client version which was compatible with 10G dlls.

-- update --

Just got off call with app guy, more issues coming up, looks like some OS
patches might be missing and also that the binaries were copied to this
server rather than actually installed. He is going to chase that down for a
while.

Thanks for your help.


On Wed, Nov 19, 2008 at 8:59 AM, Goulet, Richard <Richard.Goulet@xxxxxxxxxxx
> wrote:

>  Ethan,
>
>     First off, what crashes, the app or the database.  If it's the app
> then that should be relinked if the database then there is where a relink
> should be done.  But first off, what are the Oracle errors that the app is
> receiving?  You can be having an overflow of a double coming from the
> database into an integer in the app.  Has happen to me in the past, and
> that's not a DBA problem.
>

Other related posts: