Results 1 to 7 of 7
  1. #1
    Join Date
    Jul 2013
    Posts
    11

    Unanswered: Use of UTL_FILE Package on remote server

    Hi All,

    This is my first post on this forum

    I have a system setup in which there are 2 servers i.e. UNIX and DB server.

    Now, I'm making use of UTL_FILE package of oracle to write into a file on UNIX server.

    I'm getting the error "ORA-29283: invalid file operation" as the database is residing on the other server.

    Probably the UNIX server is denying access to the oracle user which is trying to write into a file located remotely i.e. UNIX.
    In this case I should have got invalid path error rather than invalid file operation (this is just my assumption).

    so, is there any way to resolve this issue i.e. using UTL packages of oracle to write to a file located on a remote server.

    I have come across many forums which says NO to my question, but I think there should be some way out

    Some people have said that the solution would be writing to a file locally i.e. on the DB server then do FTP for that file to the remote server. But unfortunately, I don't have access to DB server

    Thanks in advance for your help.

    Best Regards,
    Supreeth K

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    UTL_FILE runs deep inside the Oracle database engine.
    UTL_FILE can only access OS file systems that are local to the DB Server.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jul 2013
    Posts
    11
    Hi,

    Even I had the same belief as you.

    Is there any other package in oracle that can write/access a file on remote server?

    Regards,
    Supreeth K

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >Is there any other package in oracle that can write/access a file on remote server?

    post URL for any application/utility that can "write/access a file on remote server".

    the security implications for doing so are enormous!
    Last edited by anacedent; 07-08-13 at 11:32.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Actually the TEXT_IO package in oracle forms can do it
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Quote Originally Posted by beilstwh View Post
    Actually the TEXT_IO package in oracle forms can do it
    Does the TEXT_IO code does not actually run inside the DB? I think not.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  7. #7
    Join Date
    Sep 2004
    Location
    London, UK
    Posts
    565
    Quote Originally Posted by beilstwh View Post
    Actually the TEXT_IO package in oracle forms can do it
    Absolutely, a client application can write to that client machine. To send a file to an arbitrary remote server would need ftp, rcp etc.

    List of file transfer protocols - Wikipedia, the free encyclopedia
    ORACLE-BASE - FTP From PL/SQL in Oracle in Oracle

    Perhaps a drive on the remote server could be shared using NFS, Samba or similar so that it appeared as a local drive to the DB server.

Posting Permissions

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