Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> 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.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-lReceived on Tue Sep 25 2007 - 22:31:50 CDT