title: Receive a db link name as a variable in Oracle PLSQL
body: <p>I have the following function in <em>PLSQL</em> which connects remotely to different Database Links to change passwords:</p>
  
  <pre><code>FUNCTION fun_change_password(DB_LINK_VARIABLE varchar2)
      RETURN binary_integer IS
  
      jobid binary_integer;
  
    BEGIN
        dbms_job.submit@DB_LINK_VARIABLE (jobid,'begin execute immediate ''alter user MYUSER identified by mypassw''; end;');
        COMMIT;
        RETURN jobid;
    END;
  </code></pre>
  
  <p>My goal is to specify which DB Link to use sending its name in a varchar2 variable called *DB_LINK_VARIABLE*. But when I compile this into a package, the parser sends me an error: </p>
  
  <blockquote>
    <p>PLS-00352: Unable to access another database 'DB_LINK_VARIABLE'</p>
  </blockquote>
  
  <p>Obviously, I pre-configured and tested all my datalinks and works perfectly.</p>
  
  <p><strong>How can I use variable 'DB_LINK_VARIABLE' into this code?</strong> </p>