Have an amazing solution built in RAD Studio? Let us know. Looking for discounts? Visit our Special Offers page!
C++

Oracle database link, cursor, ORA-03106: fatal two-task communication protocol error

Author: Embarcadero USA

 Question and Answer Database

     FAQ: FAQ4507B - Oracle database link, cursor, ORA-03106: fatal two-task communication protocol error
Category: Database (Oracle)
Platform: All-32Bit
 Product: All-CBuilder,   BC++5.x,   C++Builder1.0,   C++Builder3.x,   C++Builder4.x,   Delphi2.x,   Delphi3.x,   Delphi4.x,   VdBase7.x,   

Question:

Why am I receiving the Oracle error ORA-03106: "fatal two-task 
communication protocol error" when using an Oracle database link
and Oracle cursors?



Answer:

SQL> print rc1
ERROR:
ORA-03106: fatal two-task communication protocol error
ORA-02063: preceding line from MARSLNK

As indicated in the SQL Plus output above this problem can be 
reproduced without using the BDE and/or BDE clients (Delphi, 
BCB, etc.).

The example SQL Plus output shows examples show the creation 
of an Oracle database link, synonym, stored procedure, package, 
package building, along with the execution and "printing" of the 
Oracle cursor data.


===========================

create public database link MARSLNK using 'srvr_tcp.borland.world'


===========================
EXECUTE PROCEDURE AND FETCH DATA FROM CURSORS VIA SQL*PLUS:

variable rctl refcursor;
execute cursortest_4(:rctl);

print rctl



variable rc1 refcursor;
execute cursortest_2(:rc1);

print rc1


===========================

create or replace procedure cursortest_4 (rc1 in out DMOD.rctl) AS

begin

open rc1 for

SELECT CUSTOMER_N, NAME

FROM IDXCUSTM

ORDER BY UPPER(NAME);

end;

===========================
create or replace procedure cursortest_2

(rc1 in out cursorpack.rctl) AS

begin

open rc1 for

SELECT *

FROM IDXCUSTM;

end;

===========================

create or replace package cursorpack IS

type rctl is ref cursor return IDXCUSTM%rowtype;

end;

===========================

create or replace PACKAGE DMOD

IS

type rctl is ref cursor;

end;

===========================

Log in to the Oracle server as the administrator to create the 
public database link:


SQL*Plus: Release 3.3.4.0.0 - Production on Thu Oct 22 16:36:15 1998

Copyright (c) Oracle Corporation 1979, 1996.  All rights reserved.


Connected to:
Oracle7 Server Release 7.3.4.0.0 - Production
With the distributed, replication and parallel query options
PL/SQL Release 2.3.4.0.0 - Production

SQL> CREATE PUBLIC DATABASE LINK MARSLNK USING 'srvr_tcp.borland.world';

Database link created.


===========================
Log into the Oracle server as user to create the synonym, packages 
and  procedures followed by execution of the procedures and 
printing/fetching the cursor rows:


SQL*Plus: Release 3.3.4.0.0 - Production on Thu Oct 22 16:40:35 1998

Copyright (c) Oracle Corporation 1979, 1996.  All rights reserved.


Connected to:
Oracle7 Server Release 7.3.4.0.0 - Production
With the distributed, replication and parallel query options
PL/SQL Release 2.3.4.0.0 - Production

SQL> CREATE SYNONYM IDXCUSTM FOR [email protected];

Synonym created.

SQL> create or replace PACKAGE DMOD
  2  
  2  IS
  3  
  3  type rctl is ref cursor;
  4  
  4  end;
  5  /

Package created.

SQL> create or replace package cursorpack IS
  2  
  2  type rctl is ref cursor return IDXCUSTM%rowtype;
  3  
  3  end;
  4  /

Package created.

SQL> create or replace procedure cursortest_2
  2  
  2  (rc1 in out cursorpack.rctl) AS
  3  
  3  begin
  4  
  4  open rc1 for
  5  
  5  SELECT *
  6  
  6  FROM IDXCUSTM;
  7  
  7  end;
  8  /

Procedure created.

SQL> create or replace procedure cursortest_4 (rc1 in out DMOD.rctl) AS
  2  
  2  begin
  3  
  3  open rc1 for
  4  
  4  SELECT CUSTOMER_N, NAME
  5  
  5  FROM IDXCUSTM
  6  
  6  ORDER BY UPPER(NAME);
  7  
  7  end;
  8  /

Procedure created.

SQL> variable rctl refcursor;
SQL> execute cursortest_4(:rctl);

PL/SQL procedure successfully completed.

SQL> print rctl
ERROR:
ORA-03106: fatal two-task communication protocol error
ORA-02063: preceding line from MARSLNK



no rows selected

SQL> variable rc1 refcursor;
SQL> execute cursortest_2(:rc1);

PL/SQL procedure successfully completed.

SQL> print rc1
ERROR:
ORA-03106: fatal two-task communication protocol error
ORA-02063: preceding line from MARSLNK



no rows selected

SQL> 

7/13/99 10:49:35 AM
 

Article originally contributed by Bill Curtis


What's New for RAD Studio 11

Reduce development time and get to market faster with RAD Studio, Delphi, or C++Builder.
Design. Code. Compile. Deploy.
Start Free Trial   Upgrade Today

   Free Delphi Community Edition   Free C++Builder Community Edition

Related posts
C++Code

What Are C++ Live Data Bindings, Charts And Vectors?

InterBaseRAD Studio

How To Deploy RAD Server With An InterBase DB To Docker

News

Hit the Ground Running with InterBase

CodeDatabaseDelphiRAD Studio

6 Easy Ways to Connect to the Top Databases You Should Know

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

IN THE ARTICLES