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 : 23-04-2017
ORA-22801

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

  • ora-00473 : ARCH process terminated with error
  • ora-24401 : cannot open further connections
  • ora-30732 : table contains no user-visible columns
  • ora-10690 : Set shadow process core file dump type (Unix only)
  • ora-23435 : cannot create an updatable ROWID materialized view with LOB columns
  • ora-06702 : TLI Driver: cannot allocate context area
  • ora-22319 : type attribute information altered in ALTER TYPE
  • ora-27373 : unknown or illegal event source queue
  • ora-08323 : scnmin: close of bias lock failed
  • ora-39150 : bad flashback time
  • ora-02331 : cannot create constraint on column of datatype string
  • ora-21610 : size [string] is invalid
  • ora-12448 : policy string not applied to schema string
  • ora-02404 : specified plan table not found
  • ora-02823 : Buffer is not aligned.
  • ora-12092 : cannot online redefine replicated table "string"."string"
  • ora-02153 : invalid VALUES password string
  • ora-28271 : No permission to read user entry in LDAP directory service.
  • ora-08234 : smsget: cannot get instance listener address
  • ora-00316 : log string of thread string, type string in header is not log file
  • ora-07501 : scgtoa: $deq unexpected return
  • ora-14256 : invalid resulting partition description(s)
  • ora-01112 : media recovery not started
  • ora-28055 : the password will expire within string days
  • ora-32578 : password for SYS already specified
  • ora-24409 : client cannot understand the object
  • ora-02439 : Unique index on a deferrable constraint is not allowed
  • ora-19552 : device type string is invalid
  • ora-25273 : AQ QMN process alternate cleanup event
  • ora-07630 : smpdal: $DELTVA failure
  • 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.