"Type Mismatch Error" after Modify Column Datatype from VARCHAR2 to CLOB in LSDB (Lodestar Database).
(Doc ID 864350.1)
Last updated on JUNE 30, 2023
Applies to:
Oracle Utilities Load Analysis - Version 9.1 and laterOracle 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.
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
**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 |