Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> ORA-03106: fatal two-task communication protocol error
We have a special problem when using some stored functions (PL/SQL), which we hoped somebody out there could help us with!?
Here is some declarations and the function itself:
CREATE DATABASE LINK cdbclerk.limo
CONNECT TO CDBCLERK IDENTIFIED BY XCVYY89QQ
USING 'limo'
/
The user CDBCLERK is defined with the following roles:
- CONNECT role - EXECUTE ANY PROCEDURE - SELECT ANY TABLE
DECLARE
op_ResultCursor lpck_defs.CursorType;
res Integer;
l_IsForeigner Number; l_FirstName varchar2(100); l_LastName varchar2(100); l_Address varchar2(256);
dbms_output.put_line('res = '||to_char(res)); dbms_output.put_line('IsForeigner = '||to_char(l_IsForeigner)); dbms_output.put_line('FirstName = '||l_FirstName); dbms_output.put_line('LastName = '||l_LastName); dbms_output.put_line('Address = '||l_Address);END; The problem is when this procedure "lsf_loadperson('22222222222', op_ResultCursor);" is called from our client program written in C/C++ for Windows 32 bit (on SQL*Net 2). Then we get the following error (this is one error, not two!):
We would be very happy if you have any solution or workaround, and if you would consider this to be highly important, we would appreciate it!!
Regards,
Morten
Received on Thu Jan 08 1998 - 00:00:00 CST