SAP with Oracle 12C DB connect to SQL SERVER 2008 with oracle gateway 10.

(Doc ID 2320954.1)

Last updated on OCTOBER 27, 2017

Applies to:

Oracle Database Gateway for SQL Server - Version to [Release 12.1]
Information in this document applies to any platform.


Getting an ORA-28534: Heterogeneous Services preprocessing in the SAP log:

" *** ERROR => ORA-28534 occurred at SQL stmt (parse error offset=0)
[dbsloci.c 19335]
  Dump statement cache (after SQL error):
  INSERT INTO INT_BLOCKS@HORTAL ( "Int_PalletID", "Int_BlockStatus", "Int_CreationTimeStamp" ) VALUES \
  ( :A0 , :A1 , :A2 );
  statement for table 'INT_BLOCKS@HORTAL ':
  INSERT INTO INT_BLOCKS@HORTAL ( "Int_PalletID", "Int_BlockStatus", "Int_CreationTimeStamp" ) VALUES ( :A0 , :A1 , :A2 )
  stmt_execute() -> orc=28534 (orc1=28534), rc=99=DBSL_ERR_DB
  Dump statement cache (rc=99=DBSL_ERR_DB):
  Dumping stmt. cache (DBSL private attributes)"


This occurred after upgrading the Oracle Gateway version to 12.1.  After this, the ORA-28534: Heterogeneous Services preprocessing error appeared in the SAP LOG.  The previous Oracle Gateway, version 10, did not have this issue.


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms