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 : 24-04-2017
ORA-19160

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

  • ora-07236 : slemop: open error.
  • ora-26005 : Invalid handle for direct path load
  • ora-06743 : TLI Driver: cannot alloc t_bind
  • ora-06915 : CMX: unknown t_event in datarq
  • ora-19777 : ASM file string cannot be proxy backed up.
  • ora-24141 : rule set string.string does not exist
  • ora-29373 : resource manager is not on
  • ora-12515 : TNS:listener could not find a handler for this presentation
  • ora-12422 : max policies exceeded
  • ora-08456 : no sign in picture mask but SIGN clause in mask options
  • ora-19209 : invalid or unsupported formatting argument
  • ora-08110 : Oracle event to test SMON cleanup for online index build
  • ora-14296 : Table block size mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION
  • ora-38029 : object statistics are locked
  • ora-09706 : slsget: get_process_stats error.
  • ora-24389 : Invalid scrollable fetch parameters
  • ora-38498 : invalid stored attribute for the index object : string
  • ora-33068 : (XSAGDNGL33) In AGGMAP workspace object, the hierarchy dimension QDR over dimension workspace object must specify a positive dimension offset.
  • ora-00471 : DBWR process terminated with error
  • ora-13225 : specified index table name is too long for a spatial index
  • ora-02464 : Cluster definition can not be both HASH and INDEX
  • ora-36403 : (XSBADSPROP) number is an illegal value for system-reserved property string on workspace object.
  • ora-39055 : The string feature is not supported in version string.
  • ora-15031 : disk specification 'string' matches no disks
  • ora-13010 : an invalid number of arguments has been specified
  • ora-07431 : fork failed
  • ora-01683 : unable to extend index string.string partition string by string in tablespace string
  • ora-12482 : internal MLS error: string Error: string
  • ora-31648 : Timeout before master process string finished initialization.
  • ora-30733 : cannot specify rowid constraint on scoped ref column
  • 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.