dblink connection

created external login and through external login we are able to refer other database table,but it is not working when we are incorporating the same inside a procedure.

objective is to run a procedure in one server , it will refer to the table of another server.