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.
Under SQL Workshop, under Utilities, choose Data Workshop.
Select “Load Data” and try to load an XLS file. Getting the following error: "Specified worksheet does not exist in XLSX file."
Am I missing something that needs to be configured?
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?
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
12c: DBMS_NETWORK_ACL_ADMIN (0 Bytes)19c: PL/SQL Packages and Types Reference (0 Bytes)
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);
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.
