Hi,
I am having an issue as to how we can resolve the error ..
ORA-22813 operand value exceeds system limits
I think XMLAGG on clob is creating this issue.
Create table statements :
Create table x as Select '42' id, to_clob(null) notes from dual; [b]Please replace the to_clob(null) with text at the end.[/b]
I am just attaching just one clob record for notes column.(at the end)
SELECT XMLElement("Notes", (XMLAGG(XMLELEMENT("Text", XMLELEMENT("CHUNK", Notes))))) -- Issue here..I think. from xLooks like XMLAGG won't work on CLOB..Not sure though as I never worked on XML.
Text for CLOB..
"History: Chief Complaint: CKD PKD HPI: Charlene McDonald is a 52 y.o. female who returns for follow up of: Stage III-IV CKD secondary to PKD. Procardia severe headaches; norvasc didnt work after a few years; Noticed very salt sensitive. Drinks > 40 ounces of fluid per day. Has abd fullnessseeing GI for EGD. Increased fullness with meals. Pt denies nausea, vomiting, MS change, fatigue, or bitter taste in mouth. Patient has no dysuria, increased frequency, hematuria, or foamy urine. Little less stress recently. Son who is 27 years old has moved out of house as planned, living with girlfriend. In January, BP high . 2 week ago, ER with BP 220/108 and txed with labetolol shots. Had CT with hemangioma as in old imaging. Labetolol 300 mg tid. Diovan 40 mg daily. Notices she is very salt sensitive. Friend is asking for Tx # because she is willing to donate. But pt has not given the # yet. Bp was very high one time because forgot to take labetolol on time, so now knows to take on time. Review Of Systems: Complete ROS performed. All systems negative except as detailed in HPI or below. PMH: history reviewed and without changes. "