Home » Fusion Middleware & Colab Suite » WebCenter Suite & Portal » How to FTP using Oracle
How to FTP using Oracle [message #77499] Tue, 31 August 2004 03:28 Go to next message
Sanjay Chincholikar
Messages: 1
Registered: August 2004
Junior Member
I need help on the following three things in Oracle

1) In Unix it is Possible to Merge 2 text files using the Cat Command. Can I merge two text files using Oracle PL/SQL Commands.

2) How can I send an E-Mail with attachment in Oracle

3) How can I use FTP in Oracle so that I can get or put the files from the FTP Server

I would be greatful if you will be able to provide the above information.


Thanks and regards,


Re: How to FTP using Oracle [message #77507 is a reply to message #77499] Tue, 19 October 2004 16:38 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member

1.) I'd run an O/S level command to do it. You'll need to create a script (using utl_file) and run that if your command needs to use ">", "&#124" etc.

2.) http://otn.oracle.com/sample_code/tech/pl_sql/htdocs/Utl_Smtp_Sample.html
search asktom.oracle.com for mail_pkg

3.) http://www.orafaq.com/scripts/plsql/ftpclient.txt
Previous Topic: Oracle 10G Portal - PL/SQL Portlet :: Form Submission
Next Topic: New to portal
Goto Forum:

Current Time: Sat Jan 23 05:51:10 CST 2021