Michel Cadot wrote:
> "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
That was what I hoped was indicated by the fact that fremove works. Yes.
I expect to be humbled by this one but not "that" humbled.
--
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)
Received on Mon Mar 08 2004 - 13:05:15 CST
