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?
Printable View
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?
err ftp?
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?
You could use GUI ftp interface: WinFTP ;)
you can use mod_plsql wth DAD to uplaod and download to a table
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.
Use a different ftp port ;)
use bfile instead of blob?
If I do store the file as bfile, how would I then drop it onto the filesystem in order to process.