Hi,
We have a PL/SQL procedure which retrieves millions of records from a table in xml format, stores it in xmltype variable. This xmltype variable is then converted to blob and then written to a BFILE.
The procedure worked fine when we had close to 2GB data. But now the volume of data has increased and we are getting below error:
"ORA-10260: limit size (1048576) of the PGA heap set by event 10261 exceeded"
The select query when executed independently completes without any error.
We cannot change the event 10261 limit size.
We fount that the error is thrown while executing xmltype_var.getBlobVal() function.
Is there a way to retrieve chunks of data from xmltype and then append to blob variable than retrieving in one shot? OR any other workaround?
Any pointer is appreciated.
Thanks in advance.