ORA-22957: NULL is an invalid input to powermultiset and COLLECT functions

Cause : NULL was given as input to the powermultiset or COLLECT function.

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

Give a non-null value as input

update : 26-09-2017

ORA-22957 - NULL is an invalid input to powermultiset and COLLECT functions
ORA-22957 - NULL is an invalid input to powermultiset and COLLECT functions

  • ora-07258 : spdcr: fork error, unable to create process.
  • ora-31037 : Invalid XML attribute name string
  • ora-36735 : A value exceeded the MAX specification
  • ora-06593 : %s is not supported with natively compiled PL/SQL modules
  • ora-22337 : the type of accessed object has been evolved
  • ora-14639 : SUBPARTITIONS clause can be specfied only for Hash, Composite Range Hash table/partition
  • ora-23620 : bind value size too large for PL/SQL CALL operation
  • ora-30445 : workload queries not found
  • ora-32514 : cannot dump multiple 'string' types: structure size is unknown
  • ora-32601 : value for retention cannot be provided
  • ora-06258 : NETNTT: cannot allocate context area
  • ora-23387 : replication parallel push dequeue error
  • ora-30501 : instance shutdown triggers cannot have AFTER type
  • ora-14157 : invalid subpartition name
  • ora-31033 : Requested number of XML children string exceeds maximum string
  • ora-38437 : The ADT "string" may not contain any user methods.
  • ora-06929 : CMX: error when sending ORACLE_SID
  • ora-06568 : obsolete ICD procedure called
  • ora-39960 : scope can only be SYSTEM or SESSION
  • ora-16139 : media recovery required
  • ora-01146 : cannot start online backup - file string is already in backup
  • ora-28666 : option not allowed for an index on UROWID column(s)
  • ora-13841 : SQL profile named string already exists for a different signature/category pair
  • ora-39157 : error appending extension to file "string"
  • ora-00163 : internal database name length string is greater than maximum (string)
  • ora-16566 : unsupported document type
  • ora-24319 : unable to allocate memory
  • ora-27413 : repeat interval is too long
  • ora-32033 : unsupported column aliasing
  • ora-25124 : Database link name not allowed.
  • 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.