Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: utl_file.fremove cannot remove a file named with japanese

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

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 07 Apr 2006 08:54:53 -0700
Message-ID: <1144425288.443291@yasure.drizzle.com>


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)
Received on Fri Apr 07 2006 - 10:54:53 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US