ORA-19162: XP0004 - XQuery type mismatch: invalid argument types 'string', 'string' for function 'string'

Cause : The typ eof the ragumentst hat wer epassed ot the gievn functoin was nto valid.

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

Fix thea rgument sto be o fa type papropriaet for th egiven fnuction.

update : 27-06-2017
ORA-19162

ORA-19162 - XP0004 - XQuery type mismatch: invalid argument types 'string', 'string' for function 'string'
ORA-19162 - XP0004 - XQuery type mismatch: invalid argument types 'string', 'string' for function 'string'

  • ora-39179 : unable to load table "string"."string" because of OID transform
  • ora-14458 : attempt was made to create a temporary table with INDEX organization
  • ora-01496 : specified chain row table form incorrect
  • ora-13774 : insufficient privileges to select data from the workload repository
  • ora-29886 : feature not supported for domain indexes
  • ora-32822 : subscriber string is marked for removal
  • ora-12980 : checkpoint option not allowed with SET UNUSED
  • ora-36992 : (XSRELGID09) A level relation is needed to produce a surrogate dimension gid.
  • ora-22329 : cannot alter a non-object type
  • ora-21605 : property [string] is not a property of value instances
  • ora-22982 : cannot create sub-view under this view
  • ora-28173 : certificate not provided by proxy
  • ora-29880 : such column list already indexed using another domain index and indextype
  • ora-15075 : disk(s) are not visible cluster-wide
  • ora-07404 : sfareq: Timeout occurred waiting for request to complete.
  • ora-29355 : NULL or invalid string argument specified
  • ora-02296 : cannot enable (string.string) - null values found
  • ora-01316 : Already attached to a Logminer session
  • ora-26033 : column string.string encryption properties differ for source or target table
  • ora-12514 : TNS:listener does not currently know of service requested in connect descriptor
  • ora-13870 : Database-wide SQL tracing is not enabled
  • ora-13840 : Concurrent DDL Error in create SQL profile operation.
  • ora-40103 : invalid case-id column: string
  • ora-36768 : (XSAGGCNTMOVE06) An aggregation variable and its AGGCOUNT must have the same base dimensions.
  • ora-25333 : Buffered Queue to Queue propagation did not connect to the correct instance
  • ora-10665 : Inject Evil Literals
  • ora-06602 : LU6.2 Driver: Error allocating context area
  • ora-28027 : privileged database links may be used by global users
  • ora-13067 : operator requires both parameters from the same topology
  • ora-31192 : Resource string has not been checked out
  • 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.