title: SQL*Plus how to accept text variable from prompt?
body: <p>Im very beginner in psql and i have a question.</p>
  
  <p>Here is the code:</p>
  
  <pre><code>SET serveroutput ON
  ACCEPT myVariable PROMPT "Input value: ";
  
  BEGIN
    dbms_output.put_line('My input variable is: '||&amp;myVariable);
   END;
  </code></pre>
  
  <p>Question is very simple: How can i pass text to my variable? If i input a number it is works correctly and i can read in the log my number, but if i pass a text like "mytext" instead of a number, i got an error:</p>
  
  <pre><code>    old:BEGIN
  
  
       dbms_output.put_line('My input variable is: '||&amp;myVariable);
       END;
  
  
      new:BEGIN
  
    dbms_output.put_line('My input variable is: '||mytext);
   END;
  
      Error starting at line 5 in command:
      BEGIN
        dbms_output.put_line('My input variable is: '||&amp;myVariable);
       END;
      Error report:
      ORA-06550: 2 sor, 50 oszlop:
      PLS-00201: identifier 'MYTEXT' must be declared
      ORA-06550: 2 sor, 3 oszlop:
      PL/SQL: Statement ignored
      06550. 00000 -  "line %s, column %s:\n%s"
      *Cause:    Usually a PL/SQL compilation error.
      *Action:
  </code></pre>