All errors › ORA errors
ORA-24247: Network access denied by access control list (ACL)
What it means
UTL_HTTP/UTL_SMTP/UTL_TCP tried to reach a host that is not allowed for the user.
How to fix it
Add an ACE with DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE for the host, port and principal.
Catch it before it runs
ORA Error Helper
Explains ORA-/PLS- codes inside JetBrains IDEs and DataGrip. PL/SQL Lint
Flags risky PL/SQL patterns while you type. Oracle Plan Reader
Reads execution plans and points at the slow step. PL/SQL in Practice
Kindle book with practical PL/SQL for working developers.
Explains ORA-/PLS- codes inside JetBrains IDEs and DataGrip. PL/SQL Lint
Flags risky PL/SQL patterns while you type. Oracle Plan Reader
Reads execution plans and points at the slow step. PL/SQL in Practice
Kindle book with practical PL/SQL for working developers.
Nearby errors
Updated 2026-11-12.