ORA-19206: Invalid value for query or REF CURSOR parameter

Cause : The queryString argument passed to DBMS_XMLGEN.newContext was not a valid query, or REF CURSOR.

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

Rewrite the query so that the queryString argument is a valid query or REF CURSOR.

update : 24-07-2017

ORA-19206 - Invalid value for query or REF CURSOR parameter
ORA-19206 - Invalid value for query or REF CURSOR parameter

  • ora-27159 : failure setting process scheduling priority
  • ora-12410 : internal policy error for policy: string Error: string
  • ora-29801 : missing RETURN keyword
  • ora-29346 : invalid tablespace list
  • ora-07751 : slemcr: malloc failure
  • ora-01694 : max # extents (string) reached in lob segment string.string partition string
  • ora-14552 : cannot perform a DDL, commit or rollback inside a query or DML
  • ora-06706 : TLI Driver: service not found
  • ora-13453 : GeoRaster metadata layer error
  • ora-27022 : skgfqsbi: could not allocate memory for media manager
  • ora-19333 : Invalid flags for the CREATE_DBURI operator
  • ora-06749 : TLI Driver: option not allowed across network
  • ora-31002 : Path name string is not a container
  • ora-19773 : must specify change tracking file name
  • ora-07606 : szprv: $CHKPRO failure
  • ora-19811 : cannot have files in DB_RECOVERY_FILE_DEST with keep attributes
  • ora-02777 : Stat failed on log directory
  • ora-06416 : NETCMN: error on test
  • ora-12910 : cannot specify temporary tablespace as default tablespace
  • ora-12197 : TNS:keyword-value resolution error
  • ora-31511 : name exceeds maximum length of 30 characters
  • ora-01540 : tablespace 'string' is not offline
  • ora-32051 : mapping service not available
  • ora-24002 : QUEUE_TABLE string does not exist
  • ora-08001 : maximum number of sequences per session exceeded
  • ora-01079 : ORACLE database was not properly created, operation aborted
  • ora-12418 : user string not found
  • ora-13349 : polygon boundary crosses itself
  • ora-17510 : Attempt to do i/o beyond file size
  • ora-14521 : Default tablespace string block size [string] for string string does not match existing string block size [string]
  • 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.