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

From: Brian Peasland <oracle_dba_at_nospam.peasland.net>
Date: Mon, 10 Apr 2006 02:43:00 GMT
Message-ID: <IxHJJw.5vu_at_igsrsparc2.er.usgs.gov>


> SQL> exec utl_file.fremove('HELLO', 'あいうえお.txt');
> BEGIN utl_file.fremove('HELLO', 'あいうえお.tst'); END;

Something isn't right in the above text. You are removing "----.txt" but the BEGIN/END wrappers have "----.tst" instead. The file extensions are not the same. It probably cannot find a file with a ".tst" extension because the correct extension is ".txt".

HTH,
Brian

-- 
===================================================================

Brian Peasland
oracle_dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown
Received on Mon Apr 10 2006 - 04:43:00 CEST

Original text of this message