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 : 21-08-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-02329 : column of datatype string cannot be unique or a primary key
  • ora-07597 : spguns: $GETJPIW failure
  • ora-15131 : block string of file string in diskgroup string could not be read
  • ora-22984 : view query cannot contain references to a super view
  • ora-13790 : invalid value for time limit
  • ora-29879 : cannot create multiple domain indexes on a column list using same indextype
  • ora-13405 : null or invalid dimensionSize parameter
  • ora-14116 : partition bound of partition "string" is too long
  • ora-24185 : transformation string.string does not exist
  • ora-24146 : rule string.string already exists
  • ora-38470 : cannot revoke a privilege that was not granted.
  • ora-08432 : raw data has invalid floating point data
  • ora-29868 : cannot issue DDL on a domain index marked as LOADING
  • ora-29533 : attempt to overwrite class or resource string while defining or compiling string.string
  • ora-32848 : foreign queue DOMAIN required for JMS unified connections
  • ora-26742 : Maximum number of ignored transactions exceeded
  • ora-28334 : column is already encrypted
  • ora-00316 : log string of thread string, type string in header is not log file
  • ora-30019 : Illegal rollback Segment operation in Automatic Undo mode
  • ora-22906 : cannot perform DML on expression or on nested table view column
  • ora-09937 : Chmod of ORACLE password file failed.
  • ora-16758 : the specified apply instance is not running
  • ora-15182 : ASMLIB [string] version mismatch, ORACLE version [string]
  • ora-37011 : (XSACQUIRE_LOCKED) Object workspace object is locked by another user.
  • ora-08276 : No room in nameserver for pid
  • ora-06576 : not a valid function or procedure name
  • ora-12165 : TNS:Trying to write trace file into swap space.
  • ora-04007 : MINVALUE cannot be made to exceed the current value
  • ora-02434 : cannot enable unique(string) - unique key not defined for table
  • ora-38710 : Flashback log version string is incompatible with ORACLE version string.
  • 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.