Unsolved
This post is more than 5 years old
643 Posts
0
8993
How to FTP with Oracle PL/SQL
Sometimes you need to get data from a server into your database, or from your database into a remote server. There are many ways this can be done such as SOAP or REST web service calls, database links, pipes, or external tools. Another option, illustrated here, is to use the internet standard File Transfer Protocol (FTP).
For more detail, please refer to the below link:
http://www.experts-exchange.com/Database/Oracle/PL_SQL/A_3043-How-to-FTP-with-Oracle-PL-SQL.html
dba_hba
63 Posts
0
April 26th, 2012 04:00
This article is correct in as far as it goes. However to use the external TCP services with packages such as UTL_TCP an Access Control List needs to set up and administer within the database using DBMS_NETWORK_ACL_ADMIN and DBMS_NETWORK_ACL
http://www.oracle-base.com/articles/11g/fine-grained-access-to-network-services-11gr1.php
zhaos2
643 Posts
0
April 26th, 2012 23:00
Thanks Allan! In previous versions of the Oracle, access to external services was effectively an on/off switch based on whether a user was granted execute permissions on a specific package or not. Oracle 11g introduces fine grained access to network services using access control lists (ACL) in the XML DB repository, allowing control over which users access which network resources, regardless of package grants.