title: Calling sql file from shell script with parameters
body: <p>I have developed following code to call a sql file from shell script <code>testshell.sh</code></p>
  
  <pre><code>#!/usr/bin/env ksh
  feed=`sqlplus -s uname/pwd &lt;&lt;-EOF
  @test.sql 'Test_VAl'
  /
  exit;
  EOF`
  echo $feed;
  </code></pre>
  
  <p>My sql file is <code>test.sql</code> which contains following:</p>
  
  <pre><code>   Declare
  
   attributeName varchar2(255):=&amp;1;
  BEGIN
       DBMS_OUTPUT.put_line (attributeName);
  
  END;
  </code></pre>
  
  <p>I am getting following error while execution.</p>
  
  <pre><code>old 3: attributeName varchar2(255):=&amp;1;
  new 3: attributeName varchar2(255):=Test_VAl;
  attributeName varchar2(255):=Test_VAl; test.sql testshell.sh
  ERROR at line 3:
  ORA-06550: line 3, column 31: PLS-00201: identifier 'TEST_VAL' must be declared
  ORA-06550: line 3, column 16: PL/SQL: Item ignored
  ORA-06550: line 5, column 25: PLS-00320: the declaration of the type of this expression is incomplete or malformed
  ORA-06550: line 5, column 3: PL/SQL: Statement ignored
  </code></pre>
  
  <p>Please tell me how to fix this issue.</p>