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

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 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?  

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