ORA-25330: PL/SQL associative arrays may not be used with AQ array operations

Cause : A PL/SQL associative array was provided for the payload parameter in an enqueue/dequeue array operation.

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

Use VARRAY or NESTED TABLE types with AQ array operations.

update : 29-06-2017
ORA-25330

ORA-25330 - PL/SQL associative arrays may not be used with AQ array operations
ORA-25330 - PL/SQL associative arrays may not be used with AQ array operations

  • ora-32847 : operation is not supported on this platform
  • ora-01969 : You must specify RESETLOGS or NORESETLOGS
  • ora-32615 : incorrect use of MODEL IS ANY predicate
  • ora-32131 : bind data type cannot be changed
  • ora-23373 : object group "string"."string" does not exist
  • ora-10262 : Don't check for memory leaks
  • ora-09929 : GLB of two labels is invalid
  • ora-08312 : sllfop: unrecognized processing option
  • ora-31679 : Table data object string has long columns, and longs can not be loaded/unloaded using a network link
  • ora-02767 : Less than one request descriptor was allocated per server
  • ora-23621 : Operation corresponding to script string is in progress.
  • ora-28575 : unable to open RPC connection to external procedure agent
  • ora-26033 : column string.string encryption properties differ for source or target table
  • ora-27035 : logical block size is invalid
  • ora-39054 : missing or invalid definition of the SQL output file.
  • ora-12171 : TNS:could not resolve connect identifier: string
  • ora-00102 : network protocol string cannot be used by dispatchers
  • ora-16565 : duplicate property, syntax error at "string"
  • ora-12500 : TNS:listener failed to start a dedicated server process
  • ora-13136 : null common code generated
  • ora-32624 : illegal reordering of MODEL dimensions
  • ora-27201 : skgfpcm: sbtpccommit returned error
  • ora-08463 : overflow converting decimal number to Oracle number
  • ora-24160 : name string already exists in the name value pair list
  • ora-32411 : materialized view definition query exceeds the maximum length
  • ora-37023 : (XSMLTUPD01) Object workspace object cannot be updated without dimension workspace object.
  • ora-32832 : failure string trying to acquire administration lock
  • ora-29909 : label for the ancillary operator is not a literal number
  • ora-25213 : message with specified RELATIVE_MSGID has been dequeued
  • ora-10691 : Set background process core file type (Unix only)
  • 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.