title: Loading external html/text file into pl/sql variable with flyway
body: <p>I'm changing database update scripts to be used with flyway and one of my scripts doesn't work anymore. It should load an external html file named 'my-template.html' into a PL/SQL variable to be loaded into an oracle database (11g). The sql script Looks like this:</p>
  
  <pre><code>DECLARE
    file_contents VARCHAR2(32767) := '@my-template.html';
  BEGIN 
  
  INSERT INTO my_table(id, key, value) VALUES (MY_SEQ.NEXTVAL, 'my.template.key', file_contents);
  COMMIT;
  END;
  /
  </code></pre>
  
  <p>This worked fine from command line using SQL plus but flyway can't handle the placeholder '@my-template.html'. It is written as it is into the db table.</p>
  
  <p>Flyway doesn't substitute the filename placeholder with the contents of the corresponding external file called 'my-template.html' the way SQL Plus did.</p>
  
  <p>Is there an easy alternative to load the external html file into my database via flyway?</p>