title: What is substitution variable in PL/SQL?
body: <p>I'm using this code to enter the name of the department using substitute variable.</p>
  
  <pre><code>DECLARE
  MAX_DEP_VAR NUMBER;
  BEGIN
  SELECT MAX(DEPTNO) INTO MAX_DEP_VAR
  FROM DEPT;
  INSERT INTO DEPT
  VALUES(MAX_DEP_VAR+10, &amp;DEPTNAME, NULL);
  END;
  </code></pre>
  
  <p>But it gives this error:</p>
  
  <blockquote>
    <p>ORA-06550: line 0, column 0:<br>
    PLS-00801: internal error [ph2csql_strdef_to_diana:bind]<br>
    ORA-06550: line 6, column 13:<br>
    PL/SQL: ORA-06544: PL/SQL: internal error, arguments: [ph2csql_strdef_to_diana:bind], [], [], [], [], [], [], []<br>
    ORA-06550: line 6, column 1:<br>
    PL/SQL: SQL Statement ignored</p>
  </blockquote>