DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: util_file.invalid_path

  1. #1
    Join Date
    Dec 2001
    Posts
    1
    N.T. 4.0, Oracle 8.1.6.

    I placed parameter, 'util_file_dir = *' in init.ora

    I then bounced the database.

    I recompiled the procedure.
    util_file.open still returns the invalid_path error.
    My address syntax and address is valid.

    Identical procedure worked in Oracle 8.0. Again, the file path is correct, and is located on the server that the database is located on.

    What else can I do?

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Originally posted by DwightH
    'util_file_dir = *' in init.ora
    Is this a typo? As it repeats both in your message and in the message header, I'm suspecting it is not - so this might be the source of your problems. The parameter name is UTL_FILE_DIR, not UTIL_FILE_DIR
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  3. #3
    Join Date
    Mar 2001
    Location
    Reading, U.K
    Posts
    598
    hi,
    check for the path. in UNIX its case sensitive.

    if the problem still persists send accross the code.
    thx

    Cheers!
    OraKid.

  4. #4
    Join Date
    Apr 2008
    Location
    Brazil
    Posts
    3

    reading a file

    I´m trying to read a file.
    but always I have a problem if the directory

    Code:
    CREATE OR REPLACE PROCEDURE PROC_read_file (
    		 p_directory    in varchar2, 
    		 p_file_name    in varchar2
    		 ) is
    
    file_to_read        utl_file.file_type;
    line                   varchar2(10000) := NULL;
    
    begin
        utl_file.fclose(file_to_read);
        file_to_read := utl_file.fopen(p_directory,p_file_name, 'R');
        loop
        .
        .
        .
    pass to the "file_to_read := utl_file.fopen(p_directory,p_file_name, 'R');"
    and go to the exception - invalid_path

    as the parameter p_directory in put 'C:\path' and the file 'arq1.csv' because is a excel file separate for comma

    anybody may help me?
    thanks for all

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    the directory needs to be an oracle direcotry object, not the real directory

  6. #6
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    Quote Originally Posted by davey23uk
    the directory needs to be an oracle direcotry object, not the real directory
    That's not correct, if my memory still works the way it used to do... it has to be the actual path.

    NaPraia... Would you mind in posting a whole sqplus session executing the procedure and then also posting a dir showing us the directory and its content?
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  7. #7
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492

    Talking

    Maybe the parameter name in init.ora should actually be:

    UTL_FILE_DIR=*

    and not util_file_dir!

    Ooops, just saw that Jurij Modic already had caught it...
    Last edited by LKBrwn_DBA; 04-24-2008 at 02:06 PM.
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  8. #8
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    and that the post you are replying to is 7 years old

  9. #9
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492

    Talking

    Quote Originally Posted by davey23uk
    and that the post you are replying to is 7 years old
    Wow! Has been a long day...
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  10. #10
    Join Date
    Apr 2008
    Location
    Brazil
    Posts
    3
    thanks!!
    i was forgotten to see the utl_file_dir.
    but now a have a new problem, i don´t have acess to this directory, and i don´t find the DBA to give me access.

    see you

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width