Re: Two-Task Communication Error

Contact Oracle Support. This is most likely a bug in either OCI or on the server.

                                                 Rick

In article <a9e2gt$jol$1_at_newton3.pacific.net.sg>, "Joshua says...
>
>Hi,
>
>We have faced the above mentioned error when we try to execute the pro*C
>program .
>
> Query No 1. EXEC SQL SELECT NVL(SUM(NVL(AMOUNT_DUE_REMAINING,0)),0),
>
>LPAD(NVL(SUM(NVL(AMOUNT_DUE_REMAINING,0)),0)*100,12,'0')
>
>Query No 2. EXEC SQL SELECT NVL(SUM(AMOUNT_DUE_REMAINING),:mn),
> LPAD(NVL(SUM(AMOUNT_DUE_REMAINING),:mn),:mlen,:mzero
><-
>
>The query was compiled & executed from Oracle 8.1.7.2 but gets the record
>from Oracle 8.0.6.2.
>
>From the above query, the Query No 1 gives me the following error.
>
>Oracle Error: ORA-03106: fatal two-task communication protocol error
>ORA-02063: prec
>
>So we tried by assigning some memory variable instead of constant ( Eg :
>Query 2 ) it works without any problem.
>
>Please help us to solve this two-task communication protocol error.
>
>Our env is Solaris 2.6
>
>SQL> select * from v$version;
>
>BANNER
>----------------------------------------------------------------
>Oracle8i Enterprise Edition Release 8.1.7.2.0 - Production
>PL/SQL Release 8.1.7.2.0 - Production
>CORE 8.1.7.0.0 Production
>TNS for Solaris: Version 8.1.7.2.0 - Production
>NLSRTL Version 3.4.1.0.0 - Production
>
>SVRMGR> select * from v$version;
>BANNER
>----------------------------------------------------------------
>Oracle8 Enterprise Edition Release 8.0.6.2.0 - Production
>PL/SQL Release 8.0.6.2.0 - Production
>CORE Version 4.0.6.0.0 - Production
>TNS for Solaris: Version 8.0.6.2.0 - Production
>NLSRTL Version 3.3.3.0.0 - Production
>5 rows selected.
>SVRMGR>
>
>
>Thanks in advance.
>
>Regards,
>
>Joshua.
>
>
>
>
>

                                Rick Wessman
                                Oracle Corporation

     The opinions expressed above are mine and do not necessarily reflect
                         those of Oracle Corporation.