When trying to use DB link in PL/SQL block I am getting the error ORA-04052 error occurred when look

Hi Experts,

I have successfully established heterogenous connectivity between Oracle 12C and Postgres SQL. I have defined a database link PG and the Link is working fine when

 I try to access Postgres table using select statement. Now the problem occurs when I have to execute this query from within a PL/SQL block. When I try compiling this code, Oracle throws out 'ORA-04052' error complaining it cannot lookup object postgres.employees. ERROR: relation "postgres.employees" does not exist; The problem is pl/sql compiler is prefixing the qualified table name with DB link username "postgres". Is there a way to tell Oracle not to do that? Hence I m getting the error relation doesn't exits as no such table exist at postgres end. Has anyone tried using DB/hetrogenous link in PL/SQL