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 : 26-05-2017
ORA-19037

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

  • ora-12669 : Shared server: outbound protocol does not support proxies
  • ora-25406 : could not generate a connect address
  • ora-02290 : check constraint (string.string) violated
  • ora-33315 : (XSDELDENTANON) You cannot delete workspace object while looping over unnamed composite workspace object.
  • ora-14071 : invalid option for an index used to enforce a constraint
  • ora-02756 : osnfsmnam: name translation failure
  • ora-22931 : MOVE of nested table to a different tablespace not supported
  • ora-13040 : failed to subdivide tile
  • ora-36702 : (XSRELTBL05) The format of the HIERHEIGHT function is: HIERHEIGHT(relation [,] level) level >= 1.
  • ora-13432 : GeoRaster metadata blankCellValue error
  • ora-39040 : Schema expression "string" must identify exactly one schema.
  • ora-01502 : index 'string.string' or partition of such index is in unusable state
  • ora-06957 : No SID is currently available
  • ora-27209 : syntax error in device PARMS - unknown keyword or missing =
  • ora-28108 : circular security policies detected
  • ora-19274 : XQ0054 - variable initialization failed due to circularity
  • ora-06916 : CMX: error in data read (t_datain)
  • ora-24087 : Invalid database user string
  • ora-22161 : type code [string] is not valid
  • ora-31109 : Action failed as parent resource string is locked
  • ora-29865 : indextype is invalid
  • ora-31195 : XML node 'string' (type=string) does not support this operation
  • ora-32032 : free temporary object number not available
  • ora-33247 : (CRENAME03) %K is already a value of the dependent UNIQUE concat dimension workspace object, from leaf dimension workspace object.
  • ora-39002 : invalid operation
  • ora-19618 : cannot name files after restoreValidate has been called
  • ora-16710 : the resource guard is out of memory
  • ora-29261 : bad argument
  • ora-00407 : rolling upgrade from release string.string to string.string is not allowed
  • ora-14099 : all rows in table do not qualify for specified partition
  • 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.