Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
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


Member
**

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



Hello,

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.

c:\ftp.pks
c:\ftp.pkb

can you explain please.


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


Advanced Member
***

Group: Members
Posts: 13,439
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: 27th June 2017 - 12:30 PM