My Oracle Support Banner

"Type Mismatch Error" after Modify Column Datatype from VARCHAR2 to CLOB in LSDB (Lodestar Database). (Doc ID 864350.1)

Last updated on JANUARY 30, 2022

Applies to:

Oracle Utilities Load Analysis - Version 9.1 and later
Oracle Utilities Energy Information Platform - Version 4.5 and later
Oracle Utilities Meter Data Management - Version 4.5 and later
Oracle Utilities Quotations Management - Version 4.5 and later
Oracle Utilities Billing Component - Version 4.5 and later
Information in this document applies to any platform.


**Any examples provided in this article do not represent real life personal/confidential information**
**Disclaimer:** This KM article may include the following abbreviations:
CLOB - Character large object
VARCHAR2 - variable-length character string
CCB - Oracle Utilities Customer Care and Billing
LSDB - Lodestar Database

In Oracle Utillities Meter Data Applications, after updating a column from VARCHAR2 to CLOB, users receive the error "Type Mismatch Error" when inserting data into the table.


Error began occurring after changing column metadata type.


To view full details, sign in with your My Oracle Support account.

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

In this Document

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