Re: utl_file.fremove cannot remove a file named with japanese

annms007_at_gmail.com wrote:
> i can delete a file with an english file name,
>
> exec utl_file.fremove('MYDIRECTORY', 'test.txt'); // this is
> succeed.
>
> but when i try to remove a japanese named file, ORA-29283 occured.
>
> SQL> exec utl_file.fremove('HELLO', '¤¢¤¤¤¦¤¨¤ª.txt');
> BEGIN utl_file.fremove('HELLO', '¤¢¤¤¤¦¤¨¤ª.tst'); END;
>
> *
> ÐÐ1¤Ç¥¨¥é©`¤¬°kÉú¤·¤Þ¤·¤¿¡£:
> ORA-29283: Ÿo„¿¤Ê¥Õ¥¡¥¤¥ë²Ù×÷¤Ç¤¹¡£
> ORA-06512: "SYS.UTL_FILE", ÐÐ18
> ORA-06512: "SYS.UTL_FILE", ÐÐ1051
> ORA-06512: ÐÐ1
>
> thanks in advance.

Question marks are substitution characters. Likely you have a character set mismatch.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)