ORA-19030: Method invalid for non-schema based XML Documents.

Cause : The method can be invoked on only schema based xmltype objects.

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

Don't invoke the method for non schema based xmltype objects.

update : 25-06-2017

ORA-19030 - Method invalid for non-schema based XML Documents.
ORA-19030 - Method invalid for non-schema based XML Documents.

  • ora-15059 : invalid device type for ASM disk
  • ora-14280 : all rows in table do not qualify for specified subpartition
  • ora-39766 : invaid stream specified for column array conversion
  • ora-01977 : Missing thread number
  • ora-25251 : exceeded maximum number of recipients for message
  • ora-31225 : DBMS_LDAP: invalid BER_ELEMENT
  • ora-39108 : Worker process string violated startup protocol. Worker error:
  • ora-04004 : MINVALUE must be less than MAXVALUE
  • ora-10573 : Test recovery tested redo from change string to string
  • ora-22902 : CURSOR expression not allowed
  • ora-12814 : only one CACHE or NOCACHE clause may be specified
  • ora-38435 : missing elementary attribute value or invalid name-value pairs
  • ora-01207 : file is more recent than control file - old control file
  • ora-24386 : statement/server handle is in use when being freed
  • ora-12020 : materialized view string is not registered
  • ora-38951 : Target platform string not cross platform compliant
  • ora-27463 : invalid program type string
  • ora-29384 : number of children for plan string exceeds string
  • ora-16098 : inaccessible standby database forced shutdown to protect primary
  • ora-19025 : EXTRACTVALUE returns value of only one node
  • ora-32134 : Cannot assign LOBs
  • ora-38102 : Invalid column in the INSERT WHERE Clause: string
  • ora-23310 : object group "string"."string" is not quiesced
  • ora-13620 : The task or object string is read-only and cannot be deleted or modified.
  • ora-06704 : TLI Driver: receive break message failed
  • ora-19678 : RMAN configuration value exceeds maximum length of string
  • ora-07628 : smsfre: sga not mapped
  • ora-00260 : cannot find online log sequence string for thread string
  • ora-01195 : online backup of file string needs more recovery to be consistent
  • ora-36694 : (XSRELTBL01) The value cannot be added to dimension workspace object.
  • 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.