title: ORA-00932: inconsistent datatypes: expected TIMESTAMP got TIMESTAMP
body: <p>Running the following:</p>
  
  <pre><code>CREATE OR REPLACE TYPE MT_TIMESTAMP_ERROR_TYPE 
  IS OBJECT
  (
    ID        VARCHAR(10),
    TIMEST        TIMESTAMP
  )
  ;
  
  CREATE TABLE MT_TIMESTAMP_ERROR_TABLE 
  (
    ecid        VARCHAR(10),
    startdate     DATE
  )
  ;
  
  CREATE OR REPLACE VIEW MT_TIMESTAMP_ERROR_VIEW
  OF MT_TIMESTAMP_ERROR_TYPE
  WITH OBJECT IDENTIFIER(ID)
  AS
  (
    select 
      ecid AS ID, 
      CAST(startdate as TIMESTAMP) AS TIMEST
    from MT_TIMESTAMP_ERROR_TABLE
  );
  </code></pre>
  
  <p>I got:</p>
  
  <pre><code>Error at Command Line : 23 Column : 5
  Error report -
  SQL Error: ORA-00932: inconsistent datatypes: expected TIMESTAMP got TIMESTAMP
  00932. 00000 -  "inconsistent datatypes: expected %s got %s"
  *Cause:    
  *Action:
  </code></pre>
  
  <p>Oracle version:
  Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production</p>
  
  <p>What can be the problem?</p>
  
  <p>Thanks!</p>
  
  <p>Regards,András</p>