OraFAQ Forum: SQL & PL/SQL » How to Upload From Client to FTP with PL/SQL Server Pages

Home » SQL & PL/SQL » SQL & PL/SQL » How to Upload From Client to FTP with PL/SQL Server Pages

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to Upload From Client to FTP with PL/SQL Server Pages [message #215529]

Mon, 22 January 2007 13:37

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

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://www.oracle.com/technology/products/forms/htdocs/webutil/web_util.pdf

Report message to a moderator

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

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

Report message to a moderator

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

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.

Report message to a moderator

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

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 ?

Report message to a moderator

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

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

Report message to a moderator

Previous Topic:	connect by query
Next Topic:	EXISTS Vs Correlated subquery

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 05 14:07:39 CST 2024