After 12CR1 To 12CR2 Upgrade Query Returns ORA-00932: Inconsistent Datatypes: Expected - Got CHAR (Doc ID 2730656.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

• The following query got ORA-932 on 12.2 only:
    
  SELECT
  Col1,
  .
  CASE WHEN ...,

  FROM ( SELECT SUM (col1) AS col1,
  FROM ( SELECT *
  FROM (SELECT ..
  UNION ALL
  SELECT ..
  )
  PIVOT
  (COUNT (..)
  FOR .
  IN ('col1' col1,))
  ORDER BY ..
  GROUP BY ROLLUP ..)
  LEFT OUTER JOIN ...;

   

Changes

 Query fail on 12.2 only , the query work in 12.1 and in 19c.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.