How to set encoding of the file when using UTL_FILE
Hi,
We are using HRMS 11i applications. 11.5.10.2 version. Two languages are installed in our instance. American English and Canadian French.
We have requirement to send employee details in a text file to third party vendor. We are using UTL_FILE to write details to the text file from PL/SQL procedure.
The generated output file has encoding as "UTF8". Where as vendor is not able to process this file. They required encoding as "ANSI".
How can we change the encoding to "ANSI" ?
Values of character set parametrs are as follows.
NLS_CHARACTERSET UTF8
NLS_NCHAR_CHARACTERSET UTF8
Any inputs are highly appreciated.
Regards,
Veerababu.