ORA-19163: XP0004 - XQuery type mismatch: argument type mismatch: expected - 'string' got - 'string' for function 'string'

Cause : The type of the arguments that were passed to the given function was not valid.

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

Fix the arguments to be of a type appropriate for the given function.

update : 20-08-2017
ORA-19163

ORA-19163 - XP0004 - XQuery type mismatch: argument type mismatch: expected - 'string' got - 'string' for function 'string'
ORA-19163 - XP0004 - XQuery type mismatch: argument type mismatch: expected - 'string' got - 'string' for function 'string'

  • ora-00096 : invalid value string for parameter string, must be from among string
  • ora-09912 : Malloc of name buffer(s) failed.
  • ora-19736 : can not plug a tablespace into a database using a different national character set
  • ora-23334 : column string does not exist in table or column group
  • ora-06116 : NETTCP: unable to create ORASRV process
  • ora-16753 : resource guard could not open standby database
  • ora-39772 : column array reset disallowed after OCI_CONTINUE or OCI_NEED_DATA
  • ora-07655 : slsprom:$TRNLOG failure
  • ora-16136 : Managed Standby Recovery not active
  • ora-12989 : invalid value for checkpoint interval
  • ora-09803 : Allocation of string buffer failed.
  • ora-13263 : column string in table string is not of type SDO_GEOMETRY
  • ora-31456 : error executing a procedure in the DBMS_CDC_UTILITY package
  • ora-19631 : archivelog record contains no file name
  • ora-02301 : maximum number of OIDGENERATORS is 255
  • ora-10931 : trace name context forever
  • ora-24123 : feature string is not yet implemented
  • ora-13115 : [string]_EDGE$ table does not exist
  • ora-08208 : ora_addr: cannot read from address file
  • ora-31051 : Requested access privileges not supported
  • ora-16582 : could not edit instance specific property
  • ora-27212 : some entrypoints in Media Management Library are missing
  • ora-01942 : IDENTIFIED BY and EXTERNALLY cannot both be specified
  • ora-01716 : NOSORT may not be used with a cluster index
  • ora-02704 : osndopop: fork failed
  • ora-23364 : Feature not enabled: Advanced replication
  • ora-19281 : XQ0055 - It is a static error if a Prolog contains more than one inherit-namespaces declaration
  • ora-07484 : snlkput: cannot convert(put) lock.
  • ora-37129 : (XSCCOMP04) Cannot aggregate over COMPRESSED COMPOSITE workspace object using AGGMAP workspace object. All static MODEL statements must precede all RELATION statements over the bases of the COMPRESSED COMPOSITE.
  • ora-35076 : (QFHEAD04) CAUTION: The textual data in EIF file string is encoded in a character set that is not recognized by this version of string.
  • 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.