title: Insert random data in Oracle table
body: <p>I wan to create random data in Oracle table:</p>
  
  <pre><code>CREATE TABLE EVENTS(
    EVENTID INTEGER NOT NULL,
    SOURCE VARCHAR2(50 ),
    TYPE VARCHAR2(50 ),
    EVENT_DATE DATE,
    DESCRIPTION VARCHAR2(100 )
  )
  /
  </code></pre>
  
  <p>I tried this:</p>
  
  <pre><code>BEGIN  
  FOR loop_counter IN 1..1000 
  LOOP 
  INSERT INTO EVENTS (EVENTID, SOURCE, TYPE, EVENT_DATE, DESCRIPTION) VALUES (loop_counter, loop_counter, 'warning', 
  DBMS_RANDOM.VALUE(TO_CHAR(DATE '2000-01-01','J') ,TO_CHAR(DATE '9999-12-31','J')), dbms_random.value(1,100)); 
  END LOOP; 
  COMMIT; 
  END;
  </code></pre>
  
  <p>I get this error exception</p>
  
  <blockquote>
    <p>Error report - ORA-06550: line 5, column 13: PL/SQL: ORA-00932:
    inconsistent datatypes: expected DATE got NUMBER ORA-06550: line 4,
    column 1: PL/SQL: SQL Statement ignored
    06550. 00000 -  "line %s, column %s:\n%s"
    *Cause:    Usually a PL/SQL compilation error.
    *Action:</p>
  </blockquote>
  
  <p>Can you give me advice how I can fix this issue?</p>