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 : 27-05-2017
ORA-22801

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

  • ora-38605 : FI not enough memory(stringK) for candidate generation(stringK)
  • ora-13333 : invalid LRS measure
  • ora-03237 : Initial Extent of specified size cannot be allocated in tablespace (string)
  • ora-26079 : file "string" is not part of table string.string
  • ora-12322 : unable to mount database (link name string)
  • ora-31068 : updateXML expected data format [string] instead of [string]
  • ora-01927 : cannot REVOKE privileges you did not grant
  • ora-30747 : cannot create substitutable tables or columns of non final type string.string
  • ora-07211 : slgcs: gettimeofday error, unable to get wall clock.
  • ora-12833 : Coordinator's instance not a member of parallel_instance_group
  • ora-00379 : no free buffers available in buffer pool string for block size stringK
  • ora-28555 : pass-through SQL: required parameter missing or NULL
  • ora-13784 : cannot accept SQL profiles for all statements in the "SQL Tuning Set"
  • ora-32006 : %s initialization parameter has been deprecated
  • ora-01588 : must use RESETLOGS option for database open
  • ora-30074 : GLOBAL partitioned index on TIME/TIMESTAMP WITH TIME ZONE not allowed
  • ora-06976 : X.25 Driver: endpoint creation failure
  • ora-28507 : error in data dictionary view string
  • ora-36685 : (XSDPART23) Only CONCAT partition templates can be subpartitioned.
  • ora-02485 : Invalid _trace_options parameter specification (string)
  • ora-30490 : Ambiguous expression in GROUP BY ROLLUP or CUBE list
  • ora-01463 : cannot modify column datatype with current constraint(s)
  • ora-01636 : rollback segment 'string' is already online
  • ora-02166 : ARCHIVELOG and NOARCHIVELOG specified
  • ora-30653 : reject limit reached
  • ora-07683 : sou2os: $SETPRV reset error
  • ora-02025 : all tables in the SQL statement must be at the remote database
  • ora-07802 : slbtpd: overflow while converting to packed decimal
  • ora-16623 : stale DRC UID sequence number detected
  • ora-13109 : spatial table string exists
  • 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.