Welcome Guest ( Log In | Register )



Performance Tuning Reference poster
Oracle training in Linux 

Oracle training Weblogic Book
Easy Oracle Jumpstart
Oracle training & performance tuning books
Burleson Consulting Remote DB Administration
Reply to this topicStart new topic
> FTP from Oracle pl/sql, FTP from Oracle pl/sql
Kanha Senapati
post Apr 12 2017, 01:20 AM
Post #1


Group: Members
Posts: 29
Joined: 16-July 15
From: India
Member No.: 50,711


I saw your blog ->http://www.dba-oracle.com/t_invoke_ftp_from_pl_sql.htm

but i didn't get where below 2 files are came .which you executed.


can you explain please.

Go to the top of the page
+Quote Post
post Apr 25 2017, 10:22 AM
Post #2

Advanced Member

Group: Members
Posts: 13,566
Joined: 26-January 04
Member No.: 13

Hi Kanha,

You use a combination of the UTL_TCP and UTL_FILE packages to create a simple FTP API (ftp.pks, ftp.pkb). Once the API is loaded into the appropriate schema simple FTP commands can be initiated as follows.

CREATE OR REPLACE DIRECTORY my_docs AS '/u01/app/oracle/'; SET SERVEROUTPUT ON SIZE 1000000 @c:\ftp.pks @c:\ftp.pkb

Hope this helps . . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:


Lo-Fi Version Time is now: 18th October 2017 - 12:49 AM