How to fix the Oracle error ORA-40103: invalid case-id column: string?

In this post, you’ll learn more about the Oracle ErrorORA-40103: invalid case-id column: string with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-40103: invalid case-id column: string

Reason for the Error ORA-40103: invalid case-id column: string

The case-id column was invalid. If a case-id column is specified, it must be present in the input data source. The case-id column cannot be the same as the target column, and the column’s data type is restricted to NUMBER, CHAR, and VARCHAR2 when building a GLM model with a diagnostics table.

How to fix the Error ORA-40103: invalid case-id column: string ?

You can fix this error in Oracle by following the below steps

Change the schema of your input data to supply a case-id column of appropriate data type.