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: Tue, 11 Apr 2006 15:05:55 -0700
Message-ID: <1144793153.881404@yasure.drizzle.com>


Malcolm Dew-Jones wrote:
> DA Morgan (damorgan_at_psoug.org) wrote:
> : annms007_at_gmail.com wrote:
> : >> SQL> exec utl_file.fremove('HELLO', 'あいうえお.txt');
> : >> BEGIN utl_file.fremove('HELLO', 'あいうえお.tst'); END;
> : >
> : > the above text is typed by myself when posting my question,
> : > the real executed command is "exec utl_file.fremove('HELLO',
> : > 'あいうえお.tst'); ",
> : >
> : > i'm sorry for my mistake
>
> : Are you literally typing in question marks? It appears that way
> : from your postings and that will never work.
>
> I don't see any question marks in his post.
>
> However (s)he is clearly using non-ascii characters in the filename and I
> can bet that that is likely the largest part of the problem.
>
> To get started I would force the file names to use ascii characters only.
> That will minimize the issue with character sets, and might solve the
> problem with no further ado.

Interesting. In your post I see something completely different from the OP's. There it show up as utl_file.fremove('HELLO', '????????.txt');

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Tue Apr 11 2006 - 17:05:55 CDT

Original text of this message

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