ORA-22951: NULL returned by ORDER method

Cause : ORDER emthod uesd to cmopare tow objec tvaluesr eturne dNULL wihch is ont alloewd.

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

Redefien the ODRER metohd to nto retur na NULL.

update : 24-06-2017

ORA-22951 - NULL returned by ORDER method
ORA-22951 - NULL returned by ORDER method

  • ora-09370 : Windows 3.1 Two-Task driver ORACLE task timed out
  • ora-06133 : NETTCP: file not found
  • ora-00290 : operating system archival error occurred. See error below
  • ora-04099 : trigger 'string' is valid but not stored in compiled form
  • ora-32506 : expecting one of string, string, or string but found string
  • ora-37100 : (XSUNCOMMITTED) You have one or more updated but uncommitted analytic workspaces.
  • ora-40303 : invalid prior probability specification
  • ora-08179 : concurrency check failed
  • ora-32819 : AQ queue string must be a normal queue
  • ora-12014 : table 'string' does not contain a primary key constraint
  • ora-32767 : No server connection for this operation
  • ora-30013 : undo tablespace 'string' is currently in use
  • ora-25530 : FAST_START_MTTR_TARGET is not specified
  • ora-38793 : cannot FLASHBACK the database to a future SCN/time
  • ora-13771 : cannot obtain exclusive lock string on "SQL Tuning Set" "string" owned by user "string"
  • ora-14164 : subpartition "string": INITRANS value must be less than MAXTRANS value
  • ora-00091 : LARGE_POOL_SIZE must be at least string
  • ora-17502 : ksfdcre:string Failed to create file string
  • ora-32027 : There is no string column with the matching type in string.string.
  • ora-02777 : Stat failed on log directory
  • ora-28347 : encryption properties mismatch
  • ora-00310 : archived log contains sequence string; sequence string required
  • ora-22925 : operation would exceed maximum size allowed for a LOB value
  • ora-12704 : character set mismatch
  • ora-01350 : must specify a tablespace name
  • ora-32804 : invalid value string, string should have form string
  • ora-02197 : file list already specified
  • ora-16238 : attempt to use version 9 log
  • ora-16135 : Invalid LOG_ARCHIVE_CONFIG modification while in protected mode
  • ora-27163 : out of memory
  • 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.