Oracle Database Discussions

Hi all,


We're running oracle 10.1.0.4.2 with nls_characterset AL32UTF8.
I've insert data from file which located on server into a table. After that,
I've try to retrieve the data with the "select * from table_name" command and
the ouput just display question marks like below:

select output from dlog_log;

OUTPUT
--------------------------------------------------------------------------------
????????????????????????????????????????????????????????????????????????????????
????????????????????????????????????????????????????????????????????????????????
????????????????????????????????????????????????????????????????????????????????
????????????????????????????????????????????????????????????????????????????????
????????????????????????????????????????????????????????????????????????????????


here is the step i did:

create table dlog_log (output clob);

create or replace procedure load_data
AS
l_clob clob;
l_bfile bfile;
begin

insert into dlog_log (output) values
(empty_clob())
returning output into l_clob;

l_bfile := BFILENAME ('TEMP_DIR', 'export.log');
DBMS_LOB.FILEOPEN(l_bfile);
DBMS_LOB.LOADFROMFILE(l_clob, l_bfile, dbms_lob.getlength(l_bfile));
DBMS_LOB.FILECLOSE(l_bfile);
end;

exec load_data;


select * from v$nls_parameters;

PARAMETER VALUE
------------------------- --------------------
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_CHARACTERSET AL32UTF8
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM

PARAMETER VALUE
------------------------- --------------------
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXF
F AM

NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXF
F AM TZR

NLS_DUAL_CURRENCY $
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE

PARAMETER VALUE
------------------------- --------------------
NLS_NCHAR_CONV_EXCP FALSE

19 rows selected.


How can I get rid of this problem?

Thank you so much