ORA-19037: XMLType result can not be a fragment

Cause : The select item of the query in newContextFromHierarchy() is an XML fragment.

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

Make sure the select item of the query in newContextFromHierarchy() is NOT an XML fragment

update : 22-09-2017

ORA-19037 - XMLType result can not be a fragment
ORA-19037 - XMLType result can not be a fragment

  • ora-25294 : Cannot propagate user buffered messages to a database with version lower than 10.2
  • ora-02091 : transaction rolled back
  • ora-28505 : cannot get non-Oracle system capabilities from string
  • ora-30939 : Order violation: Element 'string' may not follow element 'string'
  • ora-13039 : failed to update spatial index for element string.string.string
  • ora-06138 : NETTCP: error during connection handshake
  • ora-14038 : GLOBAL partitioned index must be prefixed
  • ora-37121 : AW Spreadsheet invalidated
  • ora-09814 : Unable to expand file name
  • ora-02197 : file list already specified
  • ora-24400 : error occured while creating connections in the pool
  • ora-10691 : Set background process core file type (Unix only)
  • ora-24785 : Cannot resume a non-migratable transaction
  • ora-40261 : input data for model build contains negative values
  • ora-01293 : mounted database required for specified LogMiner options
  • ora-29902 : error in executing ODCIIndexStart() routine
  • ora-26058 : unexpected error fetching metadata for column string in table string
  • ora-19567 : cannot shrink file string because it is being backed up or copied
  • ora-07483 : snlkget: cannot convert(get) lock.
  • ora-24056 : internal inconsistency for QUEUE string and destination string
  • ora-31525 : could not find column string in CDC change table string.string
  • ora-24041 : propagation schedule exists for QUEUE string and DESTINATION string
  • ora-00347 : log string of thread string, expected block size string doesn't match string
  • ora-16231 : DDL barrier
  • ora-19105 : invalid XQueryX: expected text node - got string
  • ora-12403 : invalid internal label
  • ora-12420 : required procedures and functions not in policy package "string"
  • ora-12067 : empty refresh groups are not allowed
  • ora-02207 : invalid INITRANS option value
  • ora-29294 : A data error occurred during compression or uncompression.
  • 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.