ORA-1410 When Executing DBMS_NETWORK_ACL_ADMIN.CREATE_ACL (Doc ID 1125375.1)

Last updated on JUNE 21, 2012

Applies to:

Oracle Server - Enterprise Edition - Version 11.1.0.6 to 11.2.0.2 [Release 11.1 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 21-Jun-2012***

Symptoms

When trying to create Access Control Lists with dbms_network_acl_admin.create_acl the execution of the procedure fails with an ORA-01410 error.



SQL> begin
2  dbms_network_acl_admin.create_acl (
3  acl             => 'Mail_UTL_Access.xml',
4  description     => 'Mail UTL Network Access',
5  principal       => 'SAGE',
6  is_grant        => TRUE,
7  privilege       => 'connect',
8  start_date      => null,
9  end_date        => null
10  );
11  end;
12  /
begin
*
ERROR at line 1:
ORA-01410: ROWID invalid
ORA-06512: at "SYS.DBMS_NETWORK_ACL_ADMIN", line 252
ORA-06512: at line 2

Changes


Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms