RE: ORA-03124: two-task internal error - any thoughts?
- From: "Best, David" <David.Best@xxxxxxxxxx>
- To: "Vlad Sadilovskiy" <vlovsky@xxxxxxxxx>, <alvaro.fernandez@xxxxxxxxx>
- Date: Tue, 25 Sep 2007 23:53:17 -0400
Hey,
Thanks for the suggestions... I tried the update manually through the
same client, different client versions, etc and couldn't reproduce the
error. I was able to solve the users problem tho via another method,
so there's no point to spend more time.
Tnx
________________________________
From: Vlad Sadilovskiy [mailto:vlovsky@xxxxxxxxx]
Sent: Tuesday, September 25, 2007 11:32 PM
To: alvaro.fernandez@xxxxxxxxx
Cc: Best, David; oracle-l@xxxxxxxxxxxxx
Subject: Re: ORA-03124: two-task internal error - any thoughts?
David,
Your client (whatever it is) is trying to store more bytes than column
can handle. Additional information that is relevant to the further
investigation is that the client is supplying UTF8 value.
Vlad Sadilovskiy
Oracle Database Tools
http://www.fourthelephant.com
On 9/20/07, Alvaro Jose Fernandez <alvaro.fernandez@xxxxxxxxx> wrote:
David,
Check with the developers, because you could be suffering one of
these bugs related to the bind value passed (I don't know your RDBMS
version). Numero of Bug and description is in bold.
alvaro
6. C++ APPLICATION THROWS ORA-03124 WHILE UPDATING LONG COLUMN
WITH NULL
Abstract: OCI7 C++ APPLICATION THROWS ORA-03124 WHILE UPDATING
LONG COLUMN WITH NULL
5497630 11-JAN-2007 Oracle Server - Enterprise Edition Solaris
Operating System (SPARC 64-bit) BUG
7. ORA-3124 OCCURS DEPENDING ON NLS SETTING.(IN OCI WITH A BIND
VARIABLE)
Hdr: 5472244 VERSION-10.2.0.1 CATEGORY-RDBMS UTILITY_VERSION-
10.2.0.1 <http://10.2.0.1/> SUB_COMPONENT-PRG INTERFACE STATUS-96 PUB-Y
PRODID-5 PORTID-197 ERROR_PREFIX-ORA ERROR_NUMBER-3124 4627522
RELEASE_ID-175
5472244 30-AUG-2006 Oracle Server - Enterprise Edition HP-UX
Itanium BUG
8. ORA-3124 INSERTING A NULL IN A CLOB
Hdr: 1528987 VERSION-8.1.6 CATEGORY-RDBMS UTILITY_VERSION-8.1.6
PRODID-5 PORTID-912 OS_VERSION-4 ERROR_PREFIX-ORA ERROR_NUMBER-3124
STATUS-80 VERSION_FIXED- 9.0.0 PUB-Y RELEASE_ID-20 IMPLST-Y
IMPACT_ID-109
1528987 22-AUG-2003 Oracle Server - Enterprise Edition
Microsoft Windows (32-bit) BUG
I used null....
ie:
UPDATE MYTABLE SET ACOL = null WHERE BCOL =
'7036874417766400004'
I'll get another trace of the manual statement......
tnx.
David,
Ok. But, then, which value of "xxxx" are you putting (in your
manual test, which works ok), for "....SET ACOL = xxxx" ? Nothing?
would you mind to send the trace excerpt corresponding to your
manual test?
This message may contain privileged and/or confidential information. If
you have received this e-mail in error or are not the intended recipient, you
may not use, copy, disseminate or distribute it; do not open any attachments,
delete it immediately from your system and notify the sender promptly by e-mail
that you have done so. Thank you.
Other related posts:
