title: ORA-02267: column type incompatible with referenced column type
body: <p>This is my coding in SQL:</p>
  
  <pre><code>CREATE TABLE TICKET (
    TICKET_NO NUMBER,
    VENUE_NO VARCHAR(3),
    TICKET_DATE   DATE,
    TICKET_PRICE NUMBER(8,2),
    PRIMARY KEY (TICKET_NO), 
      CONSTRAINT TICKET_VENUE_NO_FK
    FOREIGN KEY (VENUE_NO) REFERENCES VENUE
  );
  </code></pre>
  
  <p>This is error stated:</p>
  
  <pre><code>Error starting at line 1 in command:
  CREATE TABLE TICKET (
  TICKET_NO   NUMBER,
  VENUE_NO VARCHAR(3),
  TICKET_DATE DATE,
  TICKET_PRICE NUMBER(8,2),
  PRIMARY KEY (TICKET_NO), 
   CONSTRAINT TICKET_VENUE_NO_FK
  FOREIGN KEY (VENUE_NO) REFERENCES VENUE)
  Error at Command Line:8 Column:13
  Error report:
  SQL Error: ORA-02267: column type incompatible with referenced column type
  02267. 00000 -  "column type incompatible with referenced column type"
  *Cause:    The datatype of the referencing column is incompatible with the
  </code></pre>
  
  <p>What wrong with my coding?</p>