title: How to run sql scripts from a pl sql procedure
body: <p>I have a procedure like :</p>
  
  <pre><code>CREATE OR REPLACE PROCEDURE test is 
  BEGIN
  
    DBMS_OUTPUT.PUT_LINE('This is a Test');
  END;
  </code></pre>
  
  <p>I want to run some sql scripts stored in the current directory.
  I could run them from sqlplus with '@scriptname.sql' but how can i do it from inside the procedure ?  For ex:</p>
  
  <pre><code>CREATE OR REPLACE PROCEDURE test is 
  BEGIN
  
    DBMS_OUTPUT.PUT_LINE('This is a Test');
    @scriptname.sql
  
  END;
  </code></pre>
  
  <p>This doesn't seem to work ! Is there a specific to run sql scripts from pl/sql procedures ?</p>