Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> How to address ORA-22813 ?
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
**
-- http://www.freelists.org/webpage/oracle-lReceived on Tue May 09 2006 - 14:47:18 CDT
![]() |
![]() |