Skip to Main Content

APEX

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.

Load excel using the Data Load option gives an error

TomekApr 1 2020 — edited Apr 8 2020

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."

pastedImage_0.png

Am I missing something that needs to be configured?

This post has been answered by Tomek on Apr 8 2020
Jump to Answer

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

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 Apr 1 2020
6 comments
1,606 views