DB LINK error when run PL/SQL
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
This will retrieve the result I want.
But does not work in PL/SQL
Anyone has clue on this ? Thanks