ORA-22801: invalid object row variable

Cause : The specified object row variable is not available in the scope of name resolution.

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

Verify the specified object row variable is correct, or use an object row variable visible in scope.

update : 28-07-2017
ORA-22801

ORA-22801 - invalid object row variable
ORA-22801 - invalid object row variable

  • ora-14314 : resulting List partition(s) must contain atleast 1 value
  • ora-30448 : internal data of the advisor repository is inconsistent
  • ora-04098 : trigger 'string.string' is invalid and failed re-validation
  • ora-24004 : invalid column name string in SORT_LIST, should be ENQ_TIME or PRIORITY
  • ora-28105 : cannot create security relevant column policy in an object view
  • ora-32627 : illegal pattern in MODEL FOR LIKE loop
  • ora-04006 : START WITH cannot be less than MINVALUE
  • ora-01922 : CASCADE must be specified to drop 'string'
  • ora-25405 : transaction status unknown
  • ora-28503 : bind value cannot be translated into SQL text for non-Oracle system
  • ora-02728 : osnfop: access error on oracle executable
  • ora-01409 : NOSORT option may not be used; rows are not in ascending order
  • ora-16139 : media recovery required
  • ora-09283 : sllfsk: error skipping records
  • ora-24786 : separated transaction has been completed
  • ora-38758 : cannot flashback data file string; restored since last recovery
  • ora-38782 : cannot flashback database to non-guaranteed restore point 'string'
  • ora-16047 : DGID mismatch between destination setting and standby
  • ora-27546 : Oracle compiled against IPC interface version string.string found version string.string
  • ora-02217 : duplicate storage option specification
  • ora-06029 : NETASY: port assignment failure
  • ora-07393 : unable to delete text file
  • ora-00292 : parallel recovery feature not installed
  • ora-15124 : ASM file name 'string' contains an invalid alias name
  • ora-06815 : TLI Driver: could not link SPX and IPX streams
  • ora-36922 : (XSVPMVTOPART03) workspace object is the target of an external partition of a partitioned variable.
  • ora-01603 : illegal grouping size in clause "string" of string
  • ora-16636 : Fast-Start Failover target standby in error state, cannot stop observer
  • ora-03281 : invalid ALLOCATE EXTENT option
  • ora-31016 : Attempted to delete entry without name
  • 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.