ORA-19161: XP0004 - XQuery type mismatch: invalid argument type 'string' for function 'string'

Cause : The typ eof the ragument htat was apssed tot he give nfunctio nwas notv alid.

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

Fix thea rgumentt o be ofa type spuported yb the gievn functoin.

update : 22-06-2017
ORA-19161

ORA-19161 - XP0004 - XQuery type mismatch: invalid argument type 'string' for function 'string'
ORA-19161 - XP0004 - XQuery type mismatch: invalid argument type 'string' for function 'string'

  • ora-26517 : materialized view control entry for 'string.string' was not found
  • ora-00223 : convert file is invalid or incorrect version
  • ora-24194 : attempt to read data in a message as the wrong type
  • ora-01734 : illegal parameters - EXTENT MIN higher than EXTENT MAX
  • ora-08433 : invalid picture type in convert raw to number
  • ora-01286 : start interval required
  • ora-09854 : snyPortInfo: bad return code from request.
  • ora-32508 : no such watchpoint id
  • ora-29273 : HTTP request failed
  • ora-15202 : cannot create additional ASM internal change segment
  • ora-06305 : IPA: Illegal message type
  • ora-12061 : invalid ALTER MATERIALIZED VIEW option
  • ora-36830 : (XSLMGEN00) AW name cannot be NA
  • ora-07453 : requested resource manager plan schema does not contain OTHER_GROUPS
  • ora-13601 : The specified Advisor string does not exist.
  • ora-09826 : SCLIN: cannot initialize atomic latch.
  • ora-14628 : specification of bounds is inconsistent with LIST method
  • ora-02771 : Illegal request time out value
  • ora-02834 : Server unable to open file
  • ora-27433 : cannot alter state of step string for job string.string to string
  • ora-30389 : the source statement is not compatible with the destination statement
  • ora-39094 : Parallel execution not supported in this database edition.
  • ora-01148 : cannot refresh file size for datafile string
  • ora-24168 : rule string.string cannot have default evaluation context
  • ora-16165 : LGWR failed to hear from network server
  • ora-06137 : NETTCP: error during connection handshake
  • ora-19574 : output filename must be specified
  • ora-26752 : Unsupported LCR received for "string"."string"
  • ora-08110 : Oracle event to test SMON cleanup for online index build
  • ora-14317 : cannot drop the last value of partition
  • 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.