ORA-19160: XP0003 - syntax error: invalid variable name string

Cause : The given XQuery variable does not begin with the '$' sign

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

Fix the variable name to start with the "$" sign.

update : 26-09-2017

ORA-19160 - XP0003 - syntax error: invalid variable name string
ORA-19160 - XP0003 - syntax error: invalid variable name string

  • ora-24417 : Session pool size has exceeded the maximum limit
  • ora-30959 : The indexed column is not stored in CLOB.
  • ora-07390 : sftopn: translate error, unable to translate file name.
  • ora-01561 : failed to remove all objects in the tablespace specified
  • ora-01863 : the year is not supported for the current calendar
  • ora-22899 : cannot specify both scope and rowid constraint on ref column
  • ora-06554 : package DBMS_STANDARD must be created before using PL/SQL
  • ora-00162 : external dbid length string is greater than maximum (string)
  • ora-12902 : default temporary tablespace must be SYSTEM or of TEMPORARY type
  • ora-06794 : TLI Driver: shadow process could not retrieve protocol info
  • ora-07427 : spstp: cannot change directory to dbs.
  • ora-29964 : missing ADD or DROP keyword
  • ora-16816 : incorrect database role
  • ora-13355 : SDO_ORDINATE_ARRAY not grouped by number of dimensions specified
  • ora-01171 : datafile string going offline due to error advancing checkpoint
  • ora-01854 : julian date must be between 1 and 5373484
  • ora-10616 : Operation not allowed on this tablespace
  • ora-19701 : device name exceeds maximum length of string
  • ora-02302 : invalid or missing type name
  • ora-13215 : window object is out of range
  • ora-36393 : (XSMXCLEA03) When using the AGGREGATES, CHANGES or CACHE options, you must specify the ALL keyword.
  • ora-25426 : remote instance does not support shared dblinks
  • ora-38903 : DML error logging is not supported for abstract column "string"
  • ora-21612 : key is already being used
  • ora-13149 : failed to generate next sequence number for spatial table string
  • ora-28655 : Alter table add overflow syntax error
  • ora-09312 : slspool: error spooling file to printer
  • ora-07417 : sfareq: One or more database writers not active.
  • ora-32644 : this function is not allowed outside of MODEL clause
  • ora-25314 : a commit-time queue table cannot be migrated to 8.0
  • 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.