Unable to read a Unicode File using UTL

From: <carla_rj_at_imagelink.com.br>
Date: 25 May 2006 06:47:27 -0700
Message-ID: <1148564847.761600.59920@y43g2000cwc.googlegroups.com>

I'm trying to read a unicode file using UTL_FILE but it doesn't work.

I used the following commands ro open and read the file:

  ARQUIVO UTL_FILE.FILE_TYPE;
  LINHA1 NVARCHAR2(500);   ARQUIVO := UTL_FILE.FOPEN_NCHAR('TESTE', 'fornecedornaoproduto.txt', 'r');
  UTL_FILE.GET_LINE_NCHAR(ARQUIVO, LINHA1); When I see the value of variable LINHA1, I see only strange caracteres. It looks like it has opened the file as ASCII instead of Unicode.

Thanks in advance for your help. Received on Thu May 25 2006 - 08:47:27 CDT

Unable to read a Unicode File using UTL_FILE