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 : 17-08-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-30013 : undo tablespace 'string' is currently in use
  • ora-01415 : too many distinct aggregate functions
  • ora-37182 : you may only specify one dimension to partition
  • ora-02422 : missing or invalid schema element
  • ora-16588 : no more internal buffers
  • ora-32815 : message system link string is referenced by a foreign queue
  • ora-01915 : invalid auditing option for views
  • ora-07607 : szaud: $SNDOPR failure
  • ora-13455 : GeoRaster metadata TRS error
  • ora-36808 : (XSTBLFUNC04) The OLAP_TABLE function LEVELREL clause cannot declare number ADT fields from number AW fields.
  • ora-29802 : missing CONTEXT keyword
  • ora-32345 : fail to refresh the materialized view string.string due to the changed synonym
  • ora-29908 : missing primary invocation for ancillary operator
  • ora-16504 : the Data Guard configuration already exists
  • ora-26093 : input data column size (number) exceeds the maximum input size (number)
  • ora-09840 : soacon: Name translation failure.
  • ora-10919 : Default temporary tablespace group must have at least one tablespace
  • ora-06909 : CMX: error during acknowledge of ORACLE_SID
  • ora-13444 : GeoRaster metadata SRS error
  • ora-08113 : composite partition index may not be compressed
  • ora-19103 : VALUE keyword keyword
  • ora-26694 : error while enqueueing into queue string.string
  • ora-22345 : recompile type string.string before attempting this operation
  • ora-30511 : invalid DDL operation in system triggers
  • ora-23610 : internal dbms_streams_tablespaces error: [string] [string] [string] [string]
  • ora-14304 : List partitioning method expects a single partitioning column
  • ora-16135 : Invalid LOG_ARCHIVE_CONFIG modification while in protected mode
  • ora-15067 : command or option incompatible with diskgroup redundancy
  • ora-19620 : %s is not of string type
  • ora-22607 : image handle already generated
  • 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.