Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: ORA-03124: two-task internal error - any thoughts?

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

From: Vlad Sadilovskiy <vlovsky_at_gmail.com>
Date: Tue, 25 Sep 2007 23:31:50 -0400
Message-ID: <df9f25d50709252031i7be6a557k62bcb43efebfbcf3@mail.gmail.com>


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.1SUB_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?
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Sep 25 2007 - 22:31:50 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US