Using PL/SQL to upload to file system
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: Using PL/SQL to upload to file system

  1. #1
    Join Date
    Jan 2001
    Posts
    66

    Using PL/SQL to upload to file system

    I can upload files to the db without a problem but... I want my user base to be able to upload from their machine to a filesystem on my server. what would be the best way to do this using 10gias?

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    err ftp?

  3. #3
    Join Date
    Jan 2001
    Posts
    66
    The ? was posted about how to develop this in PL/SQL so the end user can simply browse their local drive for a file and upload to my server. Instead of being placed in the database, I want the file dropped on the solaris file system.
    FTP is no longer an option for plenty of reasons. Or at least how would I be able to drop file stored as a blob in the database to the file system?

  4. #4
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,443

    Cool


    You could use GUI ftp interface: WinFTP
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    you can use mod_plsql wth DAD to uplaod and download to a table

  6. #6
    Join Date
    Jan 2001
    Posts
    66
    FTP is not an option for us as company guidelines force us to shutdown ftp port. I am currently able to load to the db and download from db to client - metalink script. Need to either load from client, pl/sql, to file system or from client,pl/sql,database,pl/sql,file system.

    Any ideas.

  7. #7
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Use a different ftp port
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  8. #8
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    use bfile instead of blob?

  9. #9
    Join Date
    Jan 2001
    Posts
    66
    If I do store the file as bfile, how would I then drop it onto the filesystem in order to process.

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