CODEWITHSUNDEEP
oracle-databaseoracle-apexacl
Christophe Jénot
Christophe Jénot

Reputation: 11

setting ACL in oracle cloud - APEX error ORA-24247 when creating a web source

I'm new in oracle Cloud / Apex 19.1.... and I need help :-)

  1. I try to crate a connection to a API web source : https://api.zelty.fr/2.1/ using a shared new web source.
  2. using APEX I have an error ORA-24247, due to ACL.
  3. I read a lot, and saw that i needed to create a ACL using script commands... but I don't see where I should post it ?
  4. In APEX , using SQL , it doesn't work ! In Cloud console, there is a menu " create an ACL" but it doesn't work ...

Can you help me ?? Where should I send the commands ? which one ? Thanks very much in advance

Upgrade : I tried to launch the following script in APEX / script SQL :

BEGIN
  DBMS_NETWORK_ACL_ADMIN.create_acl (
   acl => 'https://api.zelty.fr', 
   description => 'zelty',
    principal => 'LPDS',
    is_grant => TRUE,
    privilege => 'connect',
    start_date => SYSTIMESTAMP,
    end_date => NULL);

  DBMS_NETWORK_ACL_ADMIN.assign_acl (
    acl => 'https://api.zelty.fr', 
    host => '*',
    lower_port => 1,
    upper_port => 9999); 

  COMMIT;
END;

but the error was :

ORA-06550: Ligne 2, colonne 3 : PLS-00201: l'identificateur 'DBMS_NETWORK_ACL_ADMIN' doit être déclaré ORA-06512: à "SYS.WWV_DBMS_SQL_APEX_190100", ligne 592 ORA-06550: Ligne 2, colonne 3 : PL/SQL: Statement ignored ORA-06550: Ligne 11, colonne 3 : PLS-00201: l'identificateur 'DBMS_NETWORK_ACL_ADMIN' doit être déclaré ORA-06550: Ligne 11, colonne 3 : PL/SQL: Statement ignored ORA-06512: à "SYS.DBMS_SYS_SQL", ligne 1658 ORA-06512: à "SYS.WWV_DBMS_SQL_APEX_190100", ligne 578 ORA-06512: à "APEX_190100.WWV_FLOW_DYNAMIC_EXEC", ligne 2033

Upvotes: 1

Views: 1042

Answers (1)

Needle file
Needle file

Reputation: 518

For https u must use certificates. look at link for example https://davidkyanek.blogspot.com/2017/04/using-oracle-wallets-to-connect-ssl.html

Upvotes: 0

Related Questions