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