title: Error while executing sql script!
body: <p>I am defining a variable in "userdata.sql",its contents are </p>
  
  <pre><code>SET DEFINE ON;
  DEFINE name = Gaurav
  DEFINE today =10/10/2011 --variable that contain date value.
  </code></pre>
  
  <p>==================================================================================</p>
  
  <p>I am creating another file called xyz.sql</p>
  
  <pre><code>@userdata.sql
  DECLARE 
  v_date DATE;
  v_name varchar2(10);
  BEGIN
  v_date:='&amp;today';
  v_name:='&amp;name';
  dbms_output.put_line('name is '||v_name);
  dbms_output.put_line('date is '||v_date);
  end;
  </code></pre>
  
  <p>On execution of xyz.sql its throwing an error 
  ora-01840 input value not long enough for date format.
  Please suggest the solution to it.
  The RDBMS i am using is ORACLE</p>