I am not familiar with the problem, but I can imaging 2 things:
1 Are you the owner of the PL/SQL you tried to perform.
If not it may be a matter of grants.

2 If the PL/SQL is a procedure or package
, then it is started on the server.
In that case the TNSNAMES on the server must also contain
an entry of the linked-database.