Home » Other » General » ORA-22813 Operand Value exceeds System limits
ORA-22813 Operand Value exceeds System limits [message #126034] Thu, 30 June 2005 11:24 Go to next message
Messages: 2
Registered: May 2005
Location: Chennai, India
Junior Member

I got the following error in my application. Can anyone tell me any pointers to solve this problem?

ORA-22813: 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 may be too big for available memory.
This was a bug in oracle database server release and fixed in the patch set
I believe this would not be existing in oracle 9i or 10g releases. (Please let me know if this is wrong). This error could be solved by setting some database parameters to some limits. Do anyone have idea what parameter needs to be set and how to identify the limitation of the parameter? Or is there any other way to solve this problem?

Thanks in advance
Re: ORA-22813 Operand Value exceeds System limits [message #189037 is a reply to message #126034] Tue, 22 August 2006 23:03 Go to previous message
Messages: 2
Registered: March 2006
Junior Member
Hi Rohini,

Just to correct you that this error "ORA-22813 Operand Value exceeds System limits" still existing in oracle version.
i am getting this error while inserting around 4,00,000 records in a single insert into select statement.

At the moment, I dont have any solution of this!!! If you have then let me know.

Previous Topic: Oracle DB Application Vendor Questionnaire
Next Topic: Oracle Architecture
Goto Forum:

Current Time: Mon Oct 24 19:21:09 CDT 2016

Total time taken to generate the page: 0.09022 seconds