utl_file.fopen
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: utl_file.fopen

  1. #1
    Join Date
    Mar 2001
    Posts
    286

    utl_file.fopen

    For Oracle on NT, can you use utl_file.fopen to see a file on a mapped network drive?

    What am I getting this:
    ORA-29283: invalid file operation
    ORA-06512: at "SYS.UTL_FILE", line 449
    ORA-29283: invalid file operation
    ORA-06512: at line 5

  2. #2
    Join Date
    Mar 2001
    Posts
    286
    Could somebody share some hints on this?

    Is "mapped network drive" viewable from utl_file package?

  3. #3
    Join Date
    Nov 2002
    Location
    Columbia, sc
    Posts
    9
    Here is the problem with UTL_FILE, mapped network drives and NT ( I belive that this is correct - at least it may point you in the right direction )

    During the startup process of the machine, the services are started before any mapped drives are mounted. This will not allow the database to see the location specified by UTL_FILE_DIR ( you do have this specified in the init.ora file, right? ) during startup and will subsequentially not allow the process to write to the drive.

    Now I have never had to write to a mapped drive, but I ran across this while researching. You should definately check meta-link for any specific information.

  4. #4
    Join Date
    Oct 2000
    Posts
    467
    You cannot write to mapped devices with utl_file package.
    This is local to where the DB is installed.
    Secondly, have you set up utl_file_dir in your init.ora ?
    Vinit

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