How to address ORA-22813 ?

  • From: "jayaraj rengarajan" <jayaraj.rengarajan@xxxxxxxxx>
  • To: oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 9 May 2006 15:47:18 -0400

One of our application user is saying, he got this error when trying to get
the ouput using collections !?
**
*oerr ora 22813
22813, 00000, "operand value exceeds system limits"
// *Cause:  Object or Collection value was too large. The size of the value
//          might have exceeded 30k in a SORT context, or the size might be
//          too big for available memory.
// *Action:  Choose another value and retry the operation.

***

pga_aggregate_target value is set to 250MB and the DB version is 9.2.0.2

Regards,

Jay

**

Other related posts: