Re: ORA-3106: TWO-TASK ERROR

I Used HP-9000 series and Oracle version 7.2.3 all my fields not greater than 256 bytes and all data type in characters or number. the error ORA-3106 usually occur after 24 hours of running the program and program generate bout 4000 transaction/ hour.

what is base bug number mean? how do I get it.

In <53b3ee$r65_at_info1.sdrc.com>, dmriley_at_sdrc.com (Dana M. Riley) writes:
>I do not know if this is your problem, but if you have a 'long'
>field which is more than 2000 characters in length and is being
>accessed via a database link, then you will get this error. There
>are patches available for this problem. This particular bug
>was introduced with 7.1.3.
>
>If this is the case, then the bug number is 355172 for the HP.
>Unfortunately, I do not know the base bug number.
>
>In article <52vbvr$j22_at_strange.dfwmm.net>,
> tungn_at_dfwmm.net writes:
>>
>> Hi everybody,
>>
>> I wrote an embed SQL program in
>> HP-UX 9000/400, HP-UX 9000/200
>> OS 10.01 and OS 10.01
>> Oracle version 7.2.3
>>
>> From time to time I got ORA-3106: TWO-TASK ERROR.
>> I did set TWO_TASK variable to the ORACLE_SID. It didn't solve
>> my problem.
>>
>> Thank you in advance for any help.
>>
>
>--
>Dana M. Riley
>Customer Applications Engineer
>SDRC Operations, Inc.
>Milford Ohio
>
>E-Mail: Dana.Riley_at_SDRC.COM
Received on Thu Oct 10 1996 - 00:00:00 CEST