Tools for Oracle database - utl_file.fremove cannot remove a file named with japanese

Author

utl_file.fremove cannot remove a file named with japanese

annms007@gmail.com

2006-04-07, 7:25 am

aSBjYW4gZGVsZXRlIGEg
ZmlsZSB3aXRoIGFuIGVu
Z2xpc2ggZmlsZSBuYW1l
LAoKZXhlYyB1dGxf
ZmlsZS5mcmVtb3ZlKCdN
WURJUkVDVE9SWScsICd0
ZXN0LnR4dCcpOyAgICAg
ICAvLyB0aGlzIGlz
CnN1Y2NlZWQuCgpidXQg
d2hlbiBpIHRyeSB0byBy
ZW1vdmUgYSBqYXBhbmVz
ZSBuYW1lZCBmaWxl
LCBPUkEtMjkyODMgb2Nj
dXJlZC4KClNRTD4gZXhl
YyB1dGxfZmlsZS5mcmVt
b3ZlKCdIRUxMTycs
ICekoqSkpKakqKSqLnR4
dCcpOwpCRUdJTiB1dGxf
ZmlsZS5mcmVtb3ZlKCdI
RUxMTycsICekoqSk
pKakqKSqLnRzdCcpOyBF
TkQ7CgoqCtDQMaTHpail
6algpKywa8n6pLek3qS3
pL+hozoKT1JBLTI5
MjgzOiCfb4S/pMql1aWhpaSl67LZ1/ ekx6S5oaMKT1JBLTA2NT
EyOiAiU1lTLlVUTF9GSU
xFIiwg
0NAxOApPUkEtMDY1MTI6
ICJTWVMuVVRMX0ZJTEUi
LCDQ0DEwNTEKT1JBLTA2
NTEyOiDQ0DEKCnRo
YW5rcyBpbiBhZHZhbmNl
Lgo=

DA Morgan

2006-04-07, 11:23 am

annms007@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@x.washington.edu
(replace x with u to respond)

Sponsored Links