RE: ORA-03124: two-task internal error - any thoughts?

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_at_gmail.com] Sent: Tuesday, September 25, 2007 11:32 PM To: alvaro.fernandez_at_sivsa.com
Cc: Best, David; oracle-l_at_freelists.org
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_at_sivsa.com> 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.

--
http://www.freelists.org/webpage/oracle-l