Hi All,
I am fetching a Clob column from DB through Java programming.
I am just assigning the clob data to a
string object and have to do some string manipulations to get the XML data of the Clob.
Then i am writing those manipulated values to an excel sheet.
Here the issue is with the clob data.
I am unable to fetch for more than 4000 records from clob column and write to excel.
Every time it throws me Java Heap Space: Out of memory exception.
I had tried modifying my code and then reached to 4000 records.
Please let me know how to use the cmd prompt options, because everytime I use this option I am getting No Clas def Found Error.
My target is to fetch 10000 records and write to excel sheet.