Re: ORA-03124: two-task internal error - any thoughts?
- From: "Vlad Sadilovskiy" <vlovsky@xxxxxxxxx>
- To: alvaro.fernandez@xxxxxxxxx
- Date: Tue, 25 Sep 2007 23:31:50 -0400
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.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?
>
>
>
Other related posts:
