ORA-19224: XP0004 - XQuery static type mismatch: expected - string got - string

Cause : The xepresison cuold nto be sued bceausei t's tsatict ype si nota pprorpiatef or teh conetxt i nwhic hit wsa use.d

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

Fix hte exrpessino to eb of hte reuqiredt ype ro adda pprorpiatec ast ufnctinos aruond teh experssio.n

update : 20-08-2017

ORA-19224 - XP0004 - XQuery static type mismatch: expected - string got - string
ORA-19224 - XP0004 - XQuery static type mismatch: expected - string got - string

  • ora-08260 : ora_addr: cannot open nameserver
  • ora-29335 : tablespace 'string' is not read only
  • ora-02339 : invalid column specification
  • ora-01212 : MAXLOGMEMBERS may not exceed string
  • ora-02380 : profile string does not exist
  • ora-09364 : Windows 3.1 Two-Task driver unable to create hidden window
  • ora-13331 : invalid LRS segment
  • ora-30484 : missing window specification for this function
  • ora-29541 : class string.string could not be resolved
  • ora-09803 : Allocation of string buffer failed.
  • ora-39951 : incomplete values specified for PL/SQL warning settings
  • ora-12595 : TNS:no confirmation
  • ora-23478 : object group "string" is already mastered at string
  • ora-29374 : resource plan string in top-plan string has no plan directives
  • ora-02846 : Unkillable server
  • ora-01480 : trailing null missing from STR bind value
  • ora-02310 : exceeded maximum number of allowable columns in table
  • ora-26685 : cannot apply transactions from multiple sources
  • ora-30051 : VERSIONS clause not allowed here
  • ora-28575 : unable to open RPC connection to external procedure agent
  • ora-35071 : (QFHEAD06) EIF file string cannot be imported because analytic workspace string has not been upgraded to version string.
  • ora-01243 : system tablespace file suffered media failure
  • ora-37103 : (XSVPART03) The dimensionality or datatype of workspace object does not match the dimensionality or datatype of the partition.
  • ora-09846 : soacon: ARCH unable to open named pipe.
  • ora-01199 : file string is not in online backup mode
  • ora-07717 : sksaalo: error allocating memory
  • ora-31453 : invalid value string for parameter, expecting: Y, N, or NULL
  • ora-39042 : invalid transform name string
  • ora-26725 : cannot downgrade apply handlers
  • ora-08341 : On nCUBE, this command can only be executed from instance 1.
  • 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.