ORA-19026: EXTRACTVALUE can only retrieve value of leaf node

Cause : Given XPath does not point to a leaf node.

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

Rewrite the query so that a leaf node is returned.

update : 18-08-2017

ORA-19026 - EXTRACTVALUE can only retrieve value of leaf node
ORA-19026 - EXTRACTVALUE can only retrieve value of leaf node

  • ora-02212 : duplicate PCTFREE option specification
  • ora-13601 : The specified Advisor string does not exist.
  • ora-14631 : the partition bounds do not match the subpartition bounds of the partition
  • ora-32164 : Method called on Invalid Connection type
  • ora-25406 : could not generate a connect address
  • ora-31154 : invalid XML document
  • ora-31025 : Invalid document element
  • ora-01350 : must specify a tablespace name
  • ora-22335 : The client cannot work with an altered type
  • ora-01698 : a clone database may only have SYSTEM rollback segment online
  • ora-26062 : Can not continue from previous errors.
  • ora-14615 : List value 'string' specified twice in subpartitions 'string', 'string'
  • ora-13304 : failure to insert a transformed geometry object in a table
  • ora-32412 : encrypted column "string" not allowed in the materialized view log
  • ora-29516 : Aurora assertion failure: string
  • ora-00439 : feature not enabled: string
  • ora-28579 : network error during callback from external procedure agent
  • ora-13063 : relationship information table is missing data for feature table [string]
  • ora-39050 : parameter string is incompatible with parameter string
  • ora-04084 : cannot change NEW values for this trigger type
  • ora-19734 : wrong creation SCN - control file expects converted plugged-in datafile
  • ora-31203 : DBMS_LDAP: PL/SQL - Init Failed.
  • ora-38958 : Source platform string is in different byte order than target platform string
  • ora-13452 : GeoRaster metadata BIN function error
  • ora-10917 : TABLESPACE GROUP cannot be specified
  • ora-24014 : invalid value string, RETENTION_TIME should be FOREVER or non-negative
  • ora-25222 : enqueue failed, complete sender info. not provided for a queue supporting non-repudiation
  • ora-14121 : MODIFY DEFAULT ATTRIBUTES may not be combined with other operations
  • ora-06145 : NETTCP: unable to start ORASRV: images not installed
  • ora-19005 : Duplicate XMLType LOB storage option
  • 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.