This discussion is archived
1 Reply Latest reply: Dec 9, 2012 7:08 PM by Marco Gralike RSS

ORA-19279: XPTY0004 - XQuery dynamic type mismatch: expected singleton sequ

968655 Newbie
Currently Being Moderated
Hi

We are having having 11.2.0.3 version database running on LINUX x86-64. When I am trying to execute the below statements for many schemas it is throwing error.

SQL> exec DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(acl=> 'send_mail.xml', principal => 'C_804',is_grant => TRUE,PRIVILEGE => 'connect');
BEGIN DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(acl=> 'send_mail.xml', principal => 'C_804',is_grant => TRUE,PRIVILEGE => 'connect'); END;

*
ERROR at line 1:
ORA-19279: XPTY0004 - XQuery dynamic type mismatch: expected singleton sequence
- got multi-item sequence
ORA-06512: at "SYS.DBMS_NETWORK_ACL_ADMIN", line 384
ORA-06512: at line 1


SQL> exec DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(acl=> 'send_mail.xml', principal => 'C_806',is_grant => TRUE,PRIVILEGE => 'connect');
BEGIN DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(acl=> 'send_mail.xml', principal => 'C_806',is_grant => TRUE,PRIVILEGE => 'connect'); END;

*
ERROR at line 1:
ORA-19279: XPTY0004 - XQuery dynamic type mismatch: expected singleton sequence
- got multi-item sequence
ORA-06512: at "SYS.DBMS_NETWORK_ACL_ADMIN", line 384
ORA-06512: at line 1


SQL> exec DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(acl=> 'send_mail.xml', principal => 'C_690',is_grant => TRUE,PRIVILEGE => 'connect');
BEGIN DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(acl=> 'send_mail.xml', principal => 'C_690',is_grant => TRUE,PRIVILEGE => 'connect'); END;

*
ERROR at line 1:
ORA-19279: XPTY0004 - XQuery dynamic type mismatch: expected singleton sequence
- got multi-item sequence
ORA-06512: at "SYS.DBMS_NETWORK_ACL_ADMIN", line 384
ORA-06512: at line 1


SQL> exec DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(acl=> 'send_mail.xml', principal => 'BHASKAR',is_grant => TRUE,PRIVILEGE => 'connect');
BEGIN DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(acl=> 'send_mail.xml', principal => 'BHASKAR',is_grant => TRUE,PRIVILEGE => 'connect'); END;

*
ERROR at line 1:
ORA-19279: XPTY0004 - XQuery dynamic type mismatch: expected singleton sequence
- got multi-item sequence
ORA-06512: at "SYS.DBMS_NETWORK_ACL_ADMIN", line 384
ORA-06512: at line 1

Need help to resolve this issue.

Thanks
Shiyas M

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points