My Oracle Support Banner

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

Last updated on AUGUST 04, 2018

Applies to:

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


On : 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.




To view full details, 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 a vibrant support community of peers and Oracle experts.