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 : 25-04-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-07588 : spdcr: $GETJPIW get image name failure
  • ora-06532 : Subscript outside of limit
  • ora-02338 : missing or invalid column constraint specification
  • ora-02819 : Write failed
  • ora-09368 : Windows 3.1 Two-Task driver unable to spawn ORACLE
  • ora-38761 : redo log sequence string in thread string, incarnation string could not be accessed
  • ora-36912 : (XSAGDNGL48) In AGGMAP workspace object, MODEL workspace object cannot be simultaneous.
  • ora-27201 : skgfpcm: sbtpccommit returned error
  • ora-26681 : command type not supported
  • ora-39081 : failed to unsubscribe agent string from queue "string"
  • ora-30965 : fragment does not fit into the VARCHAR2 VALUE column
  • ora-38766 : cannot flashback data file string; file resized smaller
  • ora-38717 : Invalid DUMP FLASHBACK option.
  • ora-09203 : sfofi: error opening file
  • ora-22990 : LOB locators cannot span transactions
  • ora-02094 : replication option not installed
  • ora-12683 : encryption/crypto-checksumming: no Diffie-Hellman seed
  • ora-01141 : error renaming data file string - new file 'string' not found
  • ora-24089 : AQ Agent string already exists
  • ora-14054 : invalid ALTER TABLE TRUNCATE PARTITION option
  • ora-07800 : slbtpd: invalid number
  • ora-15170 : cannot add entry 'string' in directory 'string'
  • ora-12449 : Labels specified for user must be of type USER
  • ora-01084 : invalid argument in OCI call
  • ora-24322 : unable to delete an initialized mutex
  • ora-14406 : updated partition key is beyond highest legal partition key
  • ora-24310 : length specified for null connect string
  • ora-16603 : Data Guard broker detected a mismatch in configuration ID
  • ora-01690 : sort area size too small
  • ora-09364 : Windows 3.1 Two-Task driver unable to create hidden window
  • 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.