PL/SQL (MOSC)

MOSC Banner

ORA-00904: "DBMS_NETWORK_ACL_ADMIN"."CHECK_PRIVILEGE": invalid identifier

edited Jun 27, 2025 4:31PM in PL/SQL (MOSC) 5 commentsAnswered ✓

Hi,

On 19C on AIX

I ran this query that I found in Release 21 PL/SQL Packages and Types Reference:

SELECT DECODE(
DBMS_NETWORK_ACL_ADMIN.CHECK_PRIVILEGE(
'us-example-com-permissions.xml', 'SCOTT', 'resolve'),
1, 'GRANTED', 0, 'DENIED', NULL) PRIVILEGE
FROM DUAL;

and I have :

ERROR at line 2:
ORA-00904: "DBMS_NETWORK_ACL_ADMIN"."CHECK_PRIVILEGE": invalid identifier

What is wrong?

Thanks and regards.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center