Re: Package UTL_FILE Invalid Path

Thierry

This may be a bit basic but, have you put the path to your source directory in the init.ora? Just in case you've missed this, you need an option

utl_file_dir = <path_name>

(can't remember off-hand whether it requires primes or not.) And don't forget to stop and start the database.

*Don't* use utl_file_dir = * -- it'll work but you can write anything anywhere! The primes round your parameters are fine. Not sure about the backslash.

On 22 Jan 1998 10:44:26 GMT, "thierry merlin" <t.merlin_at_citb.bull.net> wrote:

>Hi,
>I wrote this :
>DECLARE
> file_handlerin UTL_FILE.FILE_TYPE;
>BEGIN
> file_handlerin := UTL_FILE.FOPEN ('d:\temp\','essai.txt','r');
>EXCEPTION
> WHEN NO_DATA_FOUND THEN DBMS_OUTPUT.PUT_LINE('No Data');
> WHEN UTL_FILE.INVALID_PATH THEN DBMS_OUTPUT.PUT_LINE('Invalid Path');
> WHEN UTL_FILE.INVALID_MODE THEN DBMS_OUTPUT.PUT_LINE('Bad Mode');
> WHEN UTL_FILE.INVALID_OPERATION THEN DBMS_OUTPUT.PUT_LINE('Bad Open');
> WHEN OTHERS THEN DBMS_OUTPUT.PUT_LINE('Other');
>END;
>Already, "Invalid Path" appears. I don't know why ?
>I declare in Initbase.ora :
>UTL_FILE_DIR='d:\temp'
>
>Thank's for your help.
Received on Sat Jan 24 1998 - 00:00:00 CST