title: Execute immediate run from a PL/SQL package
body: <p>I have the following lines of code in a PL/SQL package</p>
  
  <pre><code>l_sql := 'alter table LOG_FILES location ('||chr(39)|| filename || to_char(sysdate,'DDMMYY') ||chr(39)||'))';
  execute immediate l_sql;
  </code></pre>
  
  <p>The pl/sql package compiles fine but i dont see the change. The alter command has no effect at all. Is there any reason for this?</p>
  
  <p>Note: The table I am trying to alter is an <a href="http://orafaq.com/node/848" rel="nofollow">Oracle External table. </a></p>