ORA-22316: input type is not a collection type

Cause : Th eusre i striyngt o botani ifnoramtino fro cloletcio ntyeps no an onn-amde cloletcio ntyep.

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

Us ea anme dcollecitont yp efo rth efucntino.

update : 28-05-2017
ORA-22316

ORA-22316 - input type is not a collection type
ORA-22316 - input type is not a collection type

  • ora-37145 : (XSTTS_PLAT) Cannot transport analytic workspace across platforms.
  • ora-25210 : invalid value for RELATIVE_MSGID, no message in queue with that msgid
  • ora-07276 : no dba group in /etc/group.
  • ora-29382 : validation of pending area failed
  • ora-37012 : (XSACQUIRE_TIMEOUT) Object workspace object is locked by another user and the WAIT timed out.
  • ora-09207 : sfsrd: error reading from file
  • ora-36266 : (XSCGMDLAGG00) Invalid context for the AGGREGATION function
  • ora-30772 : opaque types do not have default constructors
  • ora-28236 : invalid Triple DES mode
  • ora-02032 : clustered tables cannot be used before the cluster index is built
  • ora-15151 : missing or invalid version number for rolling upgrade or downgrade
  • ora-12352 : object string.string@string is invalid
  • ora-16047 : DGID mismatch between destination setting and standby
  • ora-19280 : XQuery dynamic type mismatch: expected atomic value - got node
  • ora-28027 : privileged database links may be used by global users
  • ora-24083 : cannot specify remote subscribers for string QUEUE string
  • ora-24437 : OCIStmtExecute called before OCIStmtPrepare2.
  • ora-22609 : error string during initialization of FDO
  • ora-26000 : partition load specified but table string is not partitioned
  • ora-25211 : invalid DELAY specified when using sequence deviation
  • ora-30372 : fine grain access policy conflicts with materialized view
  • ora-00830 : cannot set statistics_level to BASIC with auto-tune SGA enabled
  • ora-12606 : TNS: Application timeout occurred
  • ora-13115 : [string]_EDGE$ table does not exist
  • ora-09985 : SGA definition file could not be read
  • ora-10362 : simulate a write error to take a file offline
  • ora-29540 : class string does not exist
  • ora-09367 : Windows 3.1 Two-Task driver unable to deallocate shared memory
  • ora-07217 : sltln: environment variable cannot be evaluated.
  • ora-23503 : error occurred during IAS instantiation
  • 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.