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…
thanks
Try to set the territory before connecting to sqlplus:
export NLS_LANG=AMERICAN_AMERICA
thanks I will try it next time
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.