ORA-19279: XQuery dynamic type mismatch: expected singleton sequence - got multi-item sequence

Cause : The XQuery sequence passed in had more than one item.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Correct the XQuery expression to return a single item sequence.

update : 25-04-2017
ORA-19279

ORA-19279 - XQuery dynamic type mismatch: expected singleton sequence - got multi-item sequence
ORA-19279 - XQuery dynamic type mismatch: expected singleton sequence - got multi-item sequence

  • ora-23303 : application raised generic exception during deferred RPC
  • ora-30682 : improper value for argument OPTION_FLAGS
  • ora-00298 : Missing or invalid attribute value
  • ora-24295 : max key length (string) for sorted hash cluster exceeded
  • ora-28658 : This operation is supported only for Index-Organized tables
  • ora-01120 : cannot remove online database file string
  • ora-02713 : osnprd: message receive failure
  • ora-23352 : duplicate destination for deferred transaction
  • ora-27093 : could not delete directory
  • ora-30042 : Cannot offline the undo tablespace
  • ora-02202 : no more tables permitted in this cluster
  • ora-00267 : name of archived log file not needed
  • ora-31226 : DBMS_LDAP: MOD_ARRAY size limit exceeded
  • ora-01689 : syntax error in clause "string" of string
  • ora-07415 : slpath: allocation of memory buffer failed.
  • ora-13109 : spatial table string exists
  • ora-03233 : unable to extend table string.string subpartition string by string in tablespace string
  • ora-25472 : maximum open iterators exceeded
  • ora-10637 : The segment does not exist
  • ora-38743 : Time/SCN is in the future of the database.
  • ora-27463 : invalid program type string
  • ora-02166 : ARCHIVELOG and NOARCHIVELOG specified
  • ora-36980 : (XSRELGID02) Variable workspace object must have a numeric data type.
  • ora-19335 : Invalid format type object
  • ora-01690 : sort area size too small
  • ora-24760 : invalid isolation level flags
  • ora-16582 : could not edit instance specific property
  • ora-24077 : cannot create propagation schedule for EXCEPTION queue string.string
  • ora-30978 : The XML Index is not locally partitioned.
  • ora-15191 : Internal ASM testing event number 15191
  • Oracle Database Error Messages



    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.