Hi All,
I am facing error when execute the PL/SQL which I use the dblink to retrieve data from remote database.

The error as following :
ORA-04052 : error occurred when looking up remote object PUBLIC....
ORA-00604 : error occurred at recursive SQL Level 1
ORA-00372 : file 1 cannot be modified at this time
ORA-01110 : data file 1: ....
ORA-02062 : preceding .....

For ur information, my global_names is set to FALSE.
I am able use SQL statement

for example
FROM tab@dblink;

This will retrieve the result I want.

But does not work in PL/SQL

Anyone has clue on this ? Thanks