Oracle Error ORA-29298: Character set mismatch

Oracle Error Message

ORA-29298: Character set mismatch

Reason for the Error

The character set mode in which the file was opened did not match the character set of the read or write operation.

Solution

Use the correct UTL_FILE read and write procedures which coorespond to the character set mode in which the file was opened.