Re: ORA-3106: TWO-TASK ERROR

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