Datapatch Fails with Error "ORA-00932: inconsistent datatypes: expected - got CLOB" (Doc ID 2255056.1)

Last updated on APRIL 19, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.0.2 version, Patching

Datapatch fails with errors after installing Jan DBBP


Connecting to database...OK
catcon: ALL catcon-related output will be written to /tmp/sqlpatch_catcon__catcon_1845.lst
catcon: See /tmp/sqlpatch_catcon_*.log files for output generated by scripts
catcon: See /tmp/sqlpatch_catcon__*.lst files for spool files, if any
Bootstrapping registry and package to current versions...done
  Error in bootstrap log /u01/app/oracle/cfgtoollogs/sqlpatch/bootstrap/bootstrap_DEM2_2017Apr04_08_08_43.log:
  Error at line 62: Warning: Package Body created with compilation errors.
  Error at line 68: 226/9 PL/SQL: SQL Statement ignored
  Error at line 69: 226/16 PL/SQL: ORA-00932: inconsistent datatypes: expected - got CLOB
  Error at line 70: 244/5 PL/SQL: SQL Statement ignored
  Error at line 71: 250/25 PL/SQL: ORA-00932: inconsistent datatypes: expected CLOB got -
Prereq check failed, exiting without installing any patches.



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms