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 : 25-04-2017

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

  • ora-01100 : database already mounted
  • ora-01624 : log string needed for crash recovery of instance string (thread string)
  • ora-32106 : array fetch not allowed without setBuffer on all columns
  • ora-09712 : orasrv: log archiver already connected.
  • ora-02056 : 2PC: string: bad two-phase command number string from string
  • ora-30754 : column or table string stores objects of only one type
  • ora-33452 : (ESDREAD06) Discarding compiled code for workspace object because number is now dimensioned by workspace object. It was dimensioned by workspace object when the code was compiled.
  • ora-00225 : expected size string of control file differs from actual size string
  • ora-36628 : (XSAGMODLIST03) MODEL workspace object could not be added to AGGMAP workspace object.
  • ora-01409 : NOSORT option may not be used; rows are not in ascending order
  • ora-02829 : No segment of the proper size is available
  • ora-00200 : control file could not be created
  • ora-30442 : can not find the definition for filter string
  • ora-29262 : bad URL
  • ora-25190 : an index-organized table maintenance operation may not be combined with other operations
  • ora-06554 : package DBMS_STANDARD must be created before using PL/SQL
  • ora-02730 : osnrnf: cannot find user logon directory
  • ora-00058 : DB_BLOCK_SIZE must be string to mount this database (not string)
  • ora-32060 : channel failure
  • ora-09831 : snyStartThread: failed to build the server port set.
  • ora-00965 : column aliases not allowed for '*'
  • ora-16005 : database requires recovery
  • ora-30647 : error retrieving access parameters for external table string.string
  • ora-09218 : sfrfs: failed to refresh file size
  • ora-24016 : cannot create QUEUE_TABLE, user string does not have execute privileges on QUEUE_PAYLOAD_TYPE string.string
  • ora-00029 : session is not a user session
  • ora-25125 : BUFFER_POOL storage option not allowed
  • ora-04008 : START WITH cannot be more than MAXVALUE
  • ora-29297 : The compressed representation is too big
  • ora-38773 : cannot add data file 'string' - file already part of database
  • 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.