Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Create UTF-8 File with UTL_FILE?

Tricampeon_1981Aug 21 2019 — edited Aug 21 2019

Hello friends

I have a procedure that generates a file with utlfile and makes it perfect, I have no problem, except that I need you to create it in UTf-8 format and I don't know what the instruction is to tell you, I am working with oracle 9i here I leave you my code thanks

v_file_id := UTL_FILE.fopen (c:\test.txt,'W' );

UTL_FILE.put (v_file_id, r1.DEP_NUMBER);

UTL_FILE.fclose(v_file_id);

How do I make sure they are creating it in UTF-8?

Comments
Post Details
Added on Aug 21 2019
6 comments
8,255 views