[prev in list] [next in list] [prev in thread] [next in thread]
List: odtug-webdev-l
Subject: RE: File creation/move to ftp server
From: "Scott L Lawrence" <sclawrence () usgs ! gov>
Date: 2003-11-12 15:44:33
[Download RAW message or body]
Right, I agree!
Scott
"Jeremy Ovenden"
<jovenden@hazelwe To: Multiple recipients of list ODTUG-WEBDEV-L
b.co.uk> <ODTUG-WEBDEV-L@fatcity.com>
Sent by: cc:
ml-errors@fatcity Subject: RE: File creation/move to ftp server
.com
11/12/2003 10:39
AM
Please respond to
ODTUG-WEBDEV-L
It really is probably the best solution as it enables you to control it all
from within the database and the java element is extremely simple. Good
luck!
> -----Original Message-----
> From: ml-errors@fatcity.com [mailto:ml-errors@fatcity.com]On Behalf Of
> Scott L Lawrence
> Sent: Wednesday, November 12, 2003 3:29 PM
> To: Multiple recipients of list ODTUG-WEBDEV-L
> Subject: RE: File creation/move to ftp server
>
>
>
> Thanks,
> I'll let you all know if this is the preferred solution.
>
>
>
>
>
>
> "Oldham, Matthew"
>
> <MatthewO@BaylorH To: Multiple
> recipients of list ODTUG-WEBDEV-L
> ealth.edu>
> <ODTUG-WEBDEV-L@fatcity.com>
> Sent by: cc:
>
> ml-errors@fatcity Subject: RE: File
> creation/move to ftp server
> .com
>
>
>
>
>
> 11/12/2003 09:54
>
> AM
>
> Please respond to
>
> ODTUG-WEBDEV-L
>
>
>
>
>
>
>
>
>
>
> You could create a java stored procedure (JSP) to execute a shell script
> which performs the FTP. A JSP which does this is simple - I could give
> you an example if you need it.
>
> -----Original Message-----
> Scott L Lawrence
> Sent: Wednesday, November 12, 2003 8:44 AM
> To: Multiple recipients of list ODTUG-WEBDEV-L
>
>
> We have a need to create a tab delimited file from a database query in
> our Designer generated WSG application. We can use utl_file to produce
> the file. After the file has been created it needs to be "moved" to our
> ftp server. We know we can schedule the pl/sql program with dbms_job.
>
> The unix directory where utl_file outputs is not to our ftp server.
> Therefore, we need a method to move the file from the utl_file directory
> to the ftp server. Does anyone have a simple method to do this via a
> cron job or some other "scheduled" method? Obviously, the job that
> moves the file can't move it if the pl/sql program has not already run.
>
> I realize this can be accomplished with a cron job that polls for the
> pl/sql output but I would rather not create a polling cron.
>
> Thanks,
> Scott Lawrence
> Engenius, Inc.
>
>
>
>
> --
> Thanks to everyone for making ODTUG 2003 a great success! See you in
> 2004! If you want to volunteer for a committee, visit
> http://www.odtug.com
> --
> Author: Scott L Lawrence
> INET: sclawrence@usgs.gov
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the
> message BODY, include a line containing: UNSUB ODTUG-WEBDEV-L (or the
> name of mailing list you want to be removed from). You may also send
> the HELP command for other information (like subscribing).
>
>
>
>
> This e-mail, facsimile, or letter and any files or attachments
> transmitted with it contains information that is confidential and
> privileged. This information is intended only for the use of the
> individual(s) and entity(ies) to whom it is addressed. If you are
> the intended recipient, further disclosures are prohibited without
> proper authorization. If you are not the intended recipient, any
> disclosure, copying, printing, or use of this information is
> strictly prohibited and possibly a violation of federal or state
> law and regulations. If you have received this information in
> error, please notify Baylor Health Care System immediately at
> 1-866-402-1661 or via e-mail at privacy@baylorhealth.edu. Baylor
> Health Care System, its subsidiaries, and affiliates hereby claim
> all applicable privileges related to this information.
> --
> Thanks to everyone for making ODTUG 2003 a great success! See
> you in 2004!
> If you want to volunteer for a committee, visit http://www.odtug.com
> --
> Author: Oldham, Matthew
> INET: MatthewO@BaylorHealth.edu
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ODTUG-WEBDEV-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>
>
>
>
> --
> Thanks to everyone for making ODTUG 2003 a great success! See
> you in 2004!
> If you want to volunteer for a committee, visit http://www.odtug.com
> --
> Author: Scott L Lawrence
> INET: sclawrence@usgs.gov
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ODTUG-WEBDEV-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
> ---
> Incoming mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.537 / Virus Database: 332 - Release Date: Thu 06/11/2003
>
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.537 / Virus Database: 332 - Release Date: Thu 06/11/2003
--
Thanks to everyone for making ODTUG 2003 a great success! See you in 2004!
If you want to volunteer for a committee, visit http://www.odtug.com
--
Author: Jeremy Ovenden
INET: jovenden@hazelweb.co.uk
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ODTUG-WEBDEV-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Thanks to everyone for making ODTUG 2003 a great success! See you in 2004!
If you want to volunteer for a committee, visit http://www.odtug.com
--
Author: Scott L Lawrence
INET: sclawrence@usgs.gov
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ODTUG-WEBDEV-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic