1 Reply Latest reply: Dec 9, 2012 9:08 PM by Marco Gralike RSS

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

    968655
      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