Creating an ACL receives this error: ORA-01858: a non-numeric character was found where a numeric was expected (Doc ID 1607408.1)

Last updated on DECEMBER 11, 2013

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 to 12.1.0.1 [Release 11.1 to 12.1]
Information in this document applies to any platform.

Symptoms

WHen attempting to create an ACL, the user receives the following error:

SQL> BEGIN
 2 DBMS_NETWORK_ACL_ADMIN.create_acl(
 3 acl => 'email.xml',
 4 description => 'email notification',
 5 principal => 'SCOTT',
  is_grant => TRUE,
 6 7 privilege => 'connect',
  start_date => SYSTIMESTAMP,
  end_date => NULL);
 8 9 10 COMMIT;
END;
11 /
12
BEGIN
*
ERROR at line 1:
ORA-30992: error occurred at Xpath /acl/ace[1][@start_date]
ORA-01858: a non-numeric character was found where a numeric was expected
ORA-06512: at "SYS.DBMS_NETWORK_ACL_ADMIN", line 252
ORA-06512: at line 2

Note that the error

ORA-30992: error occurred at Xpath /acl/ace[1][@start_date]

indicates that the problem is with the start_date,

start_date => SYSTIMESTAMP,

 

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