Two-Task Communication Error

From: Joshua John Cool <joshua.cool_at_pacific.net.sg>
Date: Mon, 15 Apr 2002 17:12:57 +0800
Message-ID: <a9e2gt$jol$1@newton3.pacific.net.sg>

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. Received on Mon Apr 15 2002 - 04:12:57 CDT