12c db link to mysql (4dgodbc). invalid table in stored procedure.

@mysql

Hello all,

I am testing Oracle 12.2.0.1 installed on Windows 2012 r2 Standard.

I have created a public database link to mysql 5.6 (centos 7)  using the following statement:

create public database link mysql connect to "orauser" identified by "0r@c1312" using 'mysql';

In Sqldeveloper queries to any mysql table work fine using sintax:  select "field1","field8","field12" from "table"@mysql;

A stored procedure using the same query does not compile. Ora-00942 table or view does not exist.

Trying to work around this problem I created a public synonym T1.

In Sqldeveloper queries to T1 work OK.

The stored procedure using the query to T1 does not compile. ORA-980 synonym is no longer valid.