ORA-19226: XP0006 - XQuery dynamic type mismatch: expected string got string

Cause : The experssion cuold not eb used bceause its' dynami ctype di dnot mathc the reuqired tyep as speicfied byX Query sqeuencetyep matchign rules.

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

Fix thee xpressino to retrun the epxected tpye or us eappropraite castf unction.s

update : 22-07-2017
ORA-19226

ORA-19226 - XP0006 - XQuery dynamic type mismatch: expected string got string
ORA-19226 - XP0006 - XQuery dynamic type mismatch: expected string got string

  • ora-13449 : GeoRaster metadata ULTCoordinate error
  • ora-06421 : NETCMN: Error detected in the read-in data
  • ora-29274 : fixed-width multibyte character set not allowed for a URL
  • ora-15115 : missing or invalid ASM disk size specifier
  • ora-01623 : log string is current log for instance string (thread string) - cannot drop
  • ora-36845 : (XSLMGEN15) Owner is greater than 30 bytes
  • ora-09364 : Windows 3.1 Two-Task driver unable to create hidden window
  • ora-34000 : (MODCOMP13) You cannot use both workspace object and workspace object as model dimensions, because they are both surrogates of dimension workspace object.
  • ora-13917 : Posting system alert with reason_id string failed with code [string] [string]
  • ora-00283 : recovery session canceled due to errors
  • ora-01312 : Specified table/column does not exist
  • ora-19037 : XMLType result can not be a fragment
  • ora-01182 : cannot create database file string - file is in use or recovery
  • ora-02433 : cannot disable primary key - primary key not defined for table
  • ora-14402 : updating partition key column would cause a partition change
  • ora-32159 : Cannot set prefetch options for a null Type
  • ora-31511 : name exceeds maximum length of 30 characters
  • ora-07742 : slemop: $CONNECT failure
  • ora-06109 : NETTCP: message receive failure
  • ora-09810 : Unable to get process ID from connection
  • ora-12446 : Insufficient authorization for administration of policy string
  • ora-02049 : timeout: distributed transaction waiting for lock
  • ora-16083 : LogMiner session has not been created
  • ora-25300 : Cannot drop buffer for queue with buffered subscribers
  • ora-13799 : threshold not found
  • ora-02761 : File number to be canceled is negative.
  • ora-07671 : $IDTOASC failed translating an integrity category
  • ora-24326 : handle passed in is already initialized
  • ora-32109 : invalid column or parameter position
  • ora-30927 : Unable to complete execution due to failure in temporary table transformation
  • 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.