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

Thread: utl_file.fopen

  1. #1
    Join Date
    Mar 2001


    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
    Could somebody share some hints on this?

    Is "mapped network drive" viewable from utl_file package?

  3. #3
    Join Date
    Nov 2002
    Columbia, sc
    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
    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 ?

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.