Re: UTL_FILE.RENAME

"Daniel Morgan" <damorgan_at_x.washington.edu> a écrit dans le message de news:1078724120.940321_at_yasure...
> Having a problem with a demo that is so simple I've not doubt I'll be
> totally embarrassed by the solution.
>
> Here's my code and the 9.2.0.4 W2K response:
>
> SQL> BEGIN
> 2 utl_file.frename('ORALOAD', 'test.txt', 'ORALOAD', 'x.txt', TRUE);
> 3 END frename;
> 4 /
> BEGIN
> *
> ERROR at line 1:
> ORA-29292: file rename operation failed
> ORA-06512: at "SYS.UTL_FILE", line 18
> ORA-06512: at "SYS.UTL_FILE", line 1108
> ORA-06512: at line 2
>
> I have already built demos that test every other aspect of UTL_FILE
> including fremove so I know the directory is correct and the file
> name is correct.
>
> A search of metalink was of no value.
>
> Thanks, in advance, for any help on this one.
>
> --
> Daniel Morgan
> http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
> http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
> damorgan_at_x.washington.edu
> (replace 'x' with a 'u' to reply)
>

Surely a silly question but do you check the file exists and you have the write privilege on directory?

Regards
Michel Cadot Received on Mon Mar 08 2004 - 00:26:28 CST