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

Last updated on OCTOBER 19, 2016

Applies to:

Oracle Utilities Load Analysis - Version: 9.1 and later   [Release: 9.1 and later ]
LODESTAR EIP - 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

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

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 hundreds of Community platforms