title: execute immediate over database link
body: <p>Is it possible to execute dynamic PL/SQL on a remote database via a databse link?</p>
  
  <p>I'm looking for something like:</p>
  
  <pre><code>l_stmt := 'begin null; end;';
  execute immediate l_stmt@dblink;
  </code></pre>
  
  <p>The syntax above is obviously wrong, I get <strong>PLS-00201: identifier 'L_STMT@DBLINK' must be declared</strong>.</p>
  
  <p>It is possible to create a procedure remotely and then execute it. Is there a way to execute code without creating a remote procedure?</p>
  
  <p>EDIT:
  I'm trying to work around passing a type over DB link. A remote procedure requires a parameter of type t_id_tab which is defined on the remote DB as</p>
  
  <pre><code>CREATE OR REPLACE TYPE T_ID_TAB AS TABLE OF NUMBER(12)
  </code></pre>