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 DECEMBER 04, 2019

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.
***Checked for relevance on 23-Nov-2011***


Symptoms

**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.


Changes

Error began occurring after changing column metadata type.

Cause

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
Symptoms
Changes
Cause
Solution
References

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