-
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?
-
-
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
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|