title: ORACLE SQL - invalid data type on table creation
body: <p>I am trying to set up a table in an ORACLE database and am getting an <code>invalid data type</code> error when I try to run this command:</p>
  
  <pre><code>CREATE TABLE Students (
  StudentID NUMBER(8) NOT NULL,
  FirstName VARCHAR(25) NOT NULL,
  Surname VARCHAR(25) NOT NULL,
  Address VARCHAR(100) NOT NULL,
  Postcode VARCHAR(7) NOT NULL,
  DoB DATE NOT NULL,
  Gender VARCHAR(1) NOT NULL,
  StudentCategory VARCHAR(50),
  StudyType VARCHAR(20),
  Nationality VARCHAR(20),
  SmokerStatus BOOLEAN,
  SpecialNeeds VARCHAR(30),
  Comments VARCHAR(30),
  PlacedStatus BOOLEAN,
  CourseID NUMBER(6) NOT NULL,
  AdvisorOfStudies NUMBER(6) NOT NULL,
  NextOfKin NUMBER(8) NOT NULL
  );
  </code></pre>
  
  <p>According to the error message, something is occuring 'starting on line 1'. That would mean on the actual create statement itself, rather than any of the data dictionary. I don't understand how this can be causing the <code>invalid data type</code> error.</p>
  
  <p>If anyone can spot what might be causing this, that'd be greatly appreciated!</p>
  
  <p>Error Details:</p>
  
  <p>Error report -
  SQL Error: ORA-00902: invalid datatype
  00902. 00000 -  "invalid datatype"
  *Cause:<br>
  *Action:</p>
  
  <p>Thanks,
  Mark</p>