Skip to Main Content
Forums

LiveLabs & Workshops

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

I Just Want to integrate FTP in my oracle apex in pl/sql

User_IKHJ2Feb 15 2022

I am using this code
DECLARE
l_conn UTL_TCP.connection;
BEGIN
l_conn := ftp.login('ftp.company.com', '21', 'ftpuser', 'ftppassword');
ftp.ascii(p_conn => l_conn);
ftp.get(p_conn => l_conn,
p_from_file => '/u01/app/oracle/test.txt',
p_to_dir => 'MY_DOCS',
p_to_file => 'test_get.txt');
ftp.logout(l_conn);
END;

I have created ACL and grant access to it
and still getting this error.
FTP.png

Comments

Billy Verreynne

You created an ACL. You get an ACL error. You do not detail/show the ACL created.
But you expect us to comment on what is wrong with your ACL?

ravindra Thapliyal

Hy Billy, please can you let me know what ACL really works for because I'm new to the apex and facing the same problem, do you have any docx regarding how we can use ACL in FTP

Billy Verreynne

12c:
DBMS_NETWORK_ACL_ADMIN (0 Bytes)19c:
PL/SQL Packages and Types Reference (0 Bytes)

User_IKHJ2

I have used these code for creating ACL and Add privilege.
BEGIN
DBMS_NETWORK_ACL_ADMIN.CREATE_ACL (
ACL => 'ftp.xml',
DESCRIPTION => 'Network Access Control for HRDEPT',
PRINCIPAL => 'HRDEPT',--Schema name in which app is installed
IS_GRANT => TRUE,
PRIVILEGE => 'connect');
END;

DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE (
ACL => 'ftp.xml',
PRINCIPAL => 'HRDEPT',
IS_GRANT => TRUE,
PRIVILEGE => 'connect',
POSITION => NULL);

DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL (
ACL => 'ftp.xml',
HOST => '192.168.2.150',--FTP Host Name
LOWER_PORT => NULL,
UPPER_PORT => NULL);

Billy Verreynne

Your posted SQL code uses a hostname. The ACL uses an IP. The schema does not have resolve privs.
Grant the resolve privilege in addition to the connect privilege.

1 - 5

Post Details

Added on Feb 15 2022
#oracle-apex-development-workshops
5 comments
670 views