CONNECTION FROM ORACLE TO NON-ORACLE SYSTEM (Doc ID 2020129.1)

Last updated on JUNE 17, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

Configured Oracle Database Gateway for ODBC 11.2.0.3 and create a database with MS ACCESS database, but is getting the following error when run the following PL/SQL -

declare
 v1 number;
 v2 number := 87998;
begin
  select espeunic
  into v1
  from especi@dbl_acc
  where espeunic = v2;

end;
 
ORA-28500: la conexión de ORACLE a un sistema no Oracle ha devuelto este mensaje:
[Microsoft][Controlador ODBC Microsoft Access]Función opcional no implementada {HYC00,NativeErr = 106}
ORA-02063: 2 lines precediendo a DBL_ACC
ORA-06512: en línea 6

If specifying the value directly in the where clause instead of use a bind variable, it works.

declare
 v1 number;
begin
  select espeunic
  into v1
  from especi@dbl_acc
  where espeunic = 87998;
end;

This problem does not happen when using Oracle Heterogeneous Services HSODBC 9i and 10g.

Cause

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