Oracle To Salesforce Bug (Doc ID 2477124.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

You are using Oracle Database Gateway for ODBC (DG4ODBC) on a Windows 64 bit server to connect to a Salesforce DB with an Easysoft 3rd party ODBC driver.

You encounter the following behavior:

NAME
---------
ACUQA

SQL> DECLARE
  cr NUMBER;
  rs NUMBER;
  v_name varchar2(20) := 'Test 11';
BEGIN
  cr := DBMS_HS_PASSTHROUGH.OPEN_CURSOR@DBLINK;
  DBMS_HS_PASSTHROUGH.PARSE@DBLINK (
  cr,
  ' INSERT INTO ACCOUNT ("Name")
VALUES(?) ');
  DBMS_HS_PASSTHROUGH.bind_variable@DBLINK (cr, 1,v_name);
  rs := DBMS_HS_PASSTHROUGH.EXECUTE_NON_QUERY@DBLINK (cr);
  DBMS_HS_PASSTHROUGH.CLOSE_CURSOR@DBLINK (cr);
END;
/
  2 3 4 5 6 7 8 9 10 11 12 13 14 15
DECLARE
*
ERROR at line 1:
ORA-28511: lost RPC connection to heterogeneous remote agent using SID=ORA-28511: lost RPC connection to heterogeneous remote agent using
SID=(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<IP>)(PORT=1524))(CONNECT_DATA=(SID=SFGW)))
ORA-02055: distributed update operation failed; rollback required
ORA-02063: preceding lines from ESSF
ORA-06512: at line 12
Process ID: 132533
Session ID: 539 Serial number: 7184

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.