ORA-19207: scalar parameter string of XMLELEMENT cannot have an alias.

Cause : The scalar parameter to XMLELEMENT has been qualified with an alias.

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

Remove the AS clause of the scalar element.

update : 26-05-2017

ORA-19207 - scalar parameter string of XMLELEMENT cannot have an alias.
ORA-19207 - scalar parameter string of XMLELEMENT cannot have an alias.

  • ora-19769 : missing FILE keyword
  • ora-16042 : user requested cancel immediate of managed recovery operation
  • ora-16528 : unable to allocate PGA heap
  • ora-28671 : UPDATE BLOCK REFERENCES may not be used on a partitioned index as a whole
  • ora-06754 : TLI Driver: unable to get local host address
  • ora-02161 : invalid value for MAXLOGFILES
  • ora-01190 : control file or data file string is from before the last RESETLOGS
  • ora-24083 : cannot specify remote subscribers for string QUEUE string
  • ora-24191 : the property name string has existed
  • ora-21503 : program terminated by fatal error
  • ora-29391 : %s and string must be mandatory to create a mandatory plan directive
  • ora-15077 : could not locate ASM instance serving a required diskgroup
  • ora-32510 : cannot create watchpoint on unreadable memory
  • ora-15180 : Could not open dynamic library string, error [string]
  • ora-30991 : cannot use DOM to add special attribute to schema-based parent
  • ora-32118 : Cannot perform operation on a null FILE
  • ora-26572 : %s.string.string: argument string does not match replication catalog
  • ora-16759 : resource guard unable to start SQL Apply with initial SCN
  • ora-19116 : too many xmlspace declarations
  • ora-08198 : Flashback Table is not supported on object tables, nested tables
  • ora-00317 : file type string in header is not log file
  • ora-16619 : health check timed out
  • ora-01910 : TABLES keyword expected
  • ora-14643 : Hakan factor mismatch for tables in ALTER TABLE EXCHANGE PARTITION
  • ora-25230 : invalid value string, WAIT should be non-negative
  • ora-26086 : direct path does not support triggers
  • ora-09344 : spsig: error signalling thread
  • ora-30564 : Index maintainence clause not allowed for ADD partition to RANGE partitioned tables
  • ora-09364 : Windows 3.1 Two-Task driver unable to create hidden window
  • ora-14450 : attempt to access a transactional temp table already in use
  • 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.