send file on ftp site with oracle
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: send file on ftp site with oracle

  1. #1
    Join Date
    Nov 2000
    Posts
    440
    Im on oracle 8.1.7
    How can i send a file on a ftp site with oracle.

  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Could you please make your question a bit more clear.


  3. #3
    Join Date
    Nov 2000
    Posts
    440
    is there like a dbms.ftp


    like there is for mail


    i dont want to use ftp script and run it,
    i want to use only oracle.


  4. #4
    Join Date
    Mar 2001
    Posts
    71
    You can user UTL_TCP package provided by oracle.

    HTH

    np70

  5. #5
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    You could write a C/Java/Perl program that would do the work for you and then invoke it from oracle. Volla!

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  6. #6
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Question to NP70, since TCP and FTP are two different protocol structures, how would you achieve FTP over UTL_TCP

    Interested to know more ...

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  7. #7
    Join Date
    Mar 2001
    Posts
    71
    Sam,

    I think TCP is protocol. and you can have either http or ftp
    connection to particular port using TCP.(e.g. port 80 for http)

    np70

  8. #8
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    NP70,

    Thanx for fixing my ignorence.

    Yes, you are correct, FTP layer is on top of the TCP as a result, you could use the TCP.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  9. #9
    Join Date
    Nov 2000
    Posts
    440
    could anyone give me an example with the UTL_TCP package

  10. #10
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Steeve123,

    i have closed your thread http://www.dbasupport.com/forums/new...threadid=15229 as it was a redundant post on this topic. Please refrain from posting multiple posts on the same topic.

    Ans, to your question: refer ,

    http://www.oradoc.com/ora816/server....tcp.htm#998101

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


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