Home » SQL & PL/SQL » SQL & PL/SQL » How to Upload From Client to FTP with PL/SQL Server Pages
How to Upload From Client to FTP with PL/SQL Server Pages [message #215529] Mon, 22 January 2007 13:37 Go to next message
PL/ay
Messages: 3
Registered: January 2007
Location: Turkey
Junior Member
This question maybe asked million times. But I didn't find the appropriate answer for may problem.

Is it possible to upload files from client to servers file system from a WEB PAGE made by "PL/SQL Server Pages"

In other words,
We have a web page designed with pure PL/SQL and HTML tags.
We need to upload users' (from client) files to server. Not in DB

We think that we could use FTP. There's a script at this address: http://www.oracle-base.com/articles/9i/FTPFromPLSQL9i.php

But I think that it is not compatible with "PL/SQL Server Pages"

Could you please help us to achieve our problem?

DB version: 9i R2 and 10g R2

[Updated on: Tue, 23 January 2007 07:09]

Report message to a moderator

Re: How to Upload From Client to FTP with PL/SQL Server Pages [message #215530 is a reply to message #215529] Mon, 22 January 2007 13:42 Go to previous messageGo to next message
BlackSwan
Messages: 25045
Registered: January 2009
Location: SoCal
Senior Member
http://www.oracle.com/technology/products/forms/htdocs/webutil/web_util.pdf
Re: How to Upload From Client to FTP with PL/SQL Server Pages [message #215547 is a reply to message #215530] Mon, 22 January 2007 18:15 Go to previous messageGo to next message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
It doesn't really matter how you constructed the HTML page but it does matter where you submit your page to...

http://www.oracle-base.com/articles/10g/FileUploadDownloadProcedures10g.php
http://www.oracle-base.com/articles/9i/FileUploadDownloadProcedures9i.php
Re: How to Upload From Client to FTP with PL/SQL Server Pages [message #215556 is a reply to message #215529] Mon, 22 January 2007 19:39 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
As the links andrew provided indicate, mod_plsql has built in functionality for this and makes the process very seamless. Here's a reference to the Oracle documentation that details File Upload and Download.
icon9.gif  Re: How to Upload From Client to FTP with PL/SQL Server Pages [message #215665 is a reply to message #215529] Tue, 23 January 2007 07:32 Go to previous messageGo to next message
PL/ay
Messages: 3
Registered: January 2007
Location: Turkey
Junior Member
Thank you for all; but I am very sory because of misunderstanding about my problem.
The sources you give me are for upload into a database table (as BLOB etc).

I do not need to upload into a table (BLOB).

I need to upload a file from client into servers Operation systems (Unix) folder. (eg: /usr/uploadedfiles/)

On the other hand, maybe it could be possible with using FTP
I sow a script using FTP commands with PL/SQL.
I already write the URL of that script in my first message. But that script is not for a web page (PL/SQL Server Pages)

There are 3 questions:
1) Should I use FTP and How ?
2) Is there a way to upload files into servers folder without using FTP, only by using pl/sql codes ?
3) OR any other method you will advise ?




Re: How to Upload From Client to FTP with PL/SQL Server Pages [message #215716 is a reply to message #215665] Tue, 23 January 2007 11:25 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
You can write a BLOB to file on the server.

http://www.adp-gmbh.ch/blog/2005/november/20.html
Previous Topic: connect by query
Next Topic: EXISTS Vs Correlated subquery
Goto Forum:
  


Current Time: Wed Dec 07 16:07:38 CST 2016

Total time taken to generate the page: 0.14263 seconds