Oracle Error SQL*Loader-00294: invalid name % specified in TREAT AS clause

Oracle Error Message

SQL*Loader-00294: invalid name % specified in TREAT AS clause

Reason for the Error

The type name specified in a TREAT AS clause is invalid. It might contain characters that are not valid in the client character set or a quoted string might not be terminated or the name might be too long to contain a valid schema name and type name.

Solution

Verify that the type name has valid characters and is not too long. Also, ensure that all quoted strings are terminated.