My Oracle Support Banner

Invalid Object Name 'HS_TRANSACTION_LOG'. {42S02,NativeErr = 208}[Oracle][ODBC SQL Server Driver] Using an Oracle Database Gateway (Doc ID 1549085.1)

Last updated on MAY 11, 2022

Applies to:

Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

Using the version 11.2 of an Oracle Database Gateway such as DG4MSQL the following error occurs -

ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Oracle][ODBC SQL Server Driver][SQL Server]Invalid object name 'OWNER1.HS_TRANSACTION_LOG'. {42S02,NativeErr = 208}[Oracle][ODBC SQL Server Driver][SQL Server]The cursor was not declared. {42000,NativeErr = 16945}

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


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