DBMS_NETWORK_ACL_ADMIN.CREATE_ACL returns ORA-30992

  • Published on Feb 18 2013
  • # 1,173
  • oracle

The problem – issueing CREATE_ACL for a new ACL list results in ORA-30992.

SQL> BEGIN
  2    DBMS_NETWORK_ACL_ADMIN.CREATE_ACL (
  3      acl          => 'acl_********.xml', 
  4      description  => 'Email ACL (*.*.nl + *.*.nl)',
  5      principal    => 'SYSTEM',
  6      is_grant     => TRUE, 
  7      privilege    => 'connect',
  8      start_date   => SYSTIMESTAMP,
  9      end_date     => NULL);
 10    COMMIT;
 11  end;
 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

The solution:
run the same code on the database server directly – no time to investigate as to why I get this error on remote (dba) connection…

4 thoughts on “DBMS_NETWORK_ACL_ADMIN.CREATE_ACL returns ORA-30992

  1. Levi Pereira says:

    thanks

  2. Jose says:

    Try to set the territory before connecting to sqlplus:

    export NLS_LANG=AMERICAN_AMERICA

    1. remivisser says:

      thanks I will try it next time

  3. mansoflaco says:

    I had te same issue… Solved omitting the parameter “start_date” (you have to omit “end_date” too), or setting it to NULL.
    It seems like the format of those date parameters causes a type mismatch inside the package.

Leave a Reply

Helpful? - leave your note below so I can brag

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>