ORA-03106: fatal two-task communication protocol error

From: Youichi Tamura <y-tamura_at_nriws11.nri.co.jp>
Date: Mon, 10 Oct 1994 11:51:09 GMT
Message-ID: <CxGGxA.3rD_at_nrigw11.nri.co.jp>

We're encountering a number of problems running PL/SQL programs accessing tables and other objects in a remote database. ORA-3106 is one of them.

I am ...
Connected to: ORACLE7 Server Release 7.0.15.4.2 - Production With the procedural and distributed options PL/SQL Release 2.0.17.1.0 - Production SQL*Plus: Release 3.1.2.3.1 - Production on Mon Oct 10 20:46:45 1994

To simplify the problem, I would run a dummy PL/SQL block as follows:

---

  1  declare                                          
  2  currec today%rowtype;                            
  3  cursor cur is                                    
  4  select '' from today;                            
  5  begin                                            
  6  open cur;                                        
  7  fetch cur into currec;                           
  8  close cur;                                       
  9* end;                                             
20:22:47 SQL> /                                       
declare                                               
 *                                                    
ERROR at line 1:                                      
ORA-03106: fatal two-task communication protocol error
ORA-02063: preceding line from BT1TOOL                
ORA-06512: at line 7                                  


____________________________________________________________________________

'today' is a remote table. BT1TOOL is a database link name. What is the nature of this error ORA-3106? Where should we start looking for a cure? Looks like FETCHing '' from a remote table is causing this error; is this a known problem?

In any case, I substitute null for '' and run the same script:

---

  1  declare                                                                  
  2  currec today%rowtype;                                                    
  3  cursor cur is                                                            
  4  select null from today;                                                  
  5  begin                                                                    
  6  open cur;                                                                
  7  fetch cur into currec;                                                   
  8  close cur;                                                               
  9* end;                                                                     
declare                                                                       
 *                                                                            
ERROR at line 1:                                                              

ORA-06501: PL/SQL: internal error 74806, arguments: [], [], [], [], [], [], []

---

Is this a known bug?

I am ...
Disconnected from ORACLE7 Server Release 7.0.15.4.2 - Production

With the procedural and distributed options                     
PL/SQL Release 2.0.17.1.0 - Production                          

Thank you for any help.

-- 
							Yoichi Tamura
							y-tamura_at_nri.co.jp

Received on Mon Oct 10 1994 - 12:51:09 CET