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 : 26-06-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-30946 : XML Schema Evolution warning: temporary tables not cleaned up
  • ora-02337 : not an object type column
  • ora-12496 : cannot change existing level, category, or release numbers
  • ora-09914 : Unable to open the ORACLE password file.
  • ora-31692 : The following SQL statement failed trying to insert a row into the Master table: string
  • ora-28500 : connection from ORACLE to a non-Oracle system returned this message:
  • ora-39136 : cannot specify an SCN on a transportable job
  • ora-28151 : more than one user name specified for command
  • ora-07850 : sllfop: bad option
  • ora-24804 : Lob read/write functions called while another OCI LOB read/write streaming is in progress
  • ora-29956 : warning in the execution of ODCIINDEXEXCHANGEPARTITION routine
  • ora-13524 : error encountered while retrieving baseline information
  • ora-31652 : command response message was invalid type - detaching job
  • ora-04075 : invalid trigger action
  • ora-29380 : resource plan string is currently active and cannot be deleted
  • ora-15173 : entry 'string' does not exist in directory 'string'
  • ora-07238 : slemcl: close error.
  • ora-02352 : file truncated error
  • ora-16052 : DB_UNIQUE_NAME attribute is required
  • ora-06920 : CMX: getbrkmsg illegal datatype
  • ora-09354 : Windows 32-bit Two-Task driver: ORACLE task unexpectedly died
  • ora-06521 : PL/SQL: Error mapping function
  • ora-13445 : GeoRaster metadata SRS error
  • ora-00097 : use of Oracle SQL feature not in SQL92 string Level
  • ora-10630 : Illegal syntax specified with SHRINK clause
  • ora-13147 : failed to generate MBR
  • ora-19374 : invalid staging table
  • ora-38859 : instance string (thread string) is not ready to be disabled
  • ora-07327 : smpdal: attempt to destroy pga when it was not mapped.
  • ora-12059 : prebuilt table "string"."string" does not exist
  • 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.