ORA-19023: The first argument to UPDATEXML operator has to be an XMLTYPE

Cause : Teh ifrts ragmuetn apsesdt ot h eudpaet avleu poeartro awsn o ta nXLMTPYE.

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

Rwertiet h eqeur ys otahtt h efris tagruemn tt oteh PUDTAEMXLo preaotri sX MTLYEP.

update : 27-05-2017
ORA-19023

ORA-19023 - The first argument to UPDATEXML operator has to be an XMLTYPE
ORA-19023 - The first argument to UPDATEXML operator has to be an XMLTYPE

  • ora-07240 : slemrd: seek error.
  • ora-23500 : cannot switch master for a multi-tier materialized view repgroup "string"."string"
  • ora-31219 : DBMS_LDAP: PL/SQL - Invalid LDAP notypes.
  • ora-01624 : log string needed for crash recovery of instance string (thread string)
  • ora-30054 : invalid upper limit snapshot expression
  • ora-02777 : Stat failed on log directory
  • ora-32846 : Messaging Gateway agent cannot be started; status is string
  • ora-37156 : (string)
  • ora-24004 : invalid column name string in SORT_LIST, should be ENQ_TIME or PRIORITY
  • ora-10863 : Control behavior of buffered background operations
  • ora-09924 : Can't spawn process - core dump directory not created properly
  • ora-39024 : wrong schema specified for job
  • ora-12227 : TNS:syntax error
  • ora-29520 : name string resolved to a class in schema string that could not be accessed
  • ora-10931 : trace name context forever
  • ora-28272 : Domain policy restricts password based GLOBAL user authentication.
  • ora-29296 : invalid encoded string
  • ora-07282 : sksaprd: string overflow.
  • ora-36641 : (XSDUNION20) The concat dimension must be defined as UNIQUE because base dimension workspace object contains custom member values.
  • ora-02802 : No idle servers available in parallel mode
  • ora-19634 : filename required for this function
  • ora-01116 : error in opening database file string
  • ora-22610 : error while adding a scalar to the image handle
  • ora-26689 : column datatype mismatch in LCR
  • ora-14191 : ALLOCATE STORAGE may not be specified for Composite Range partitioned object
  • ora-15007 : name is already used by an existing template
  • ora-12164 : TNS:Sqlnet.fdf file not present
  • ora-31419 : source table string does not exist
  • ora-31418 : source schema string does not exist
  • ora-10648 : Tablespace SYSAUX is not offline
  • 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.