Reason :
I was facing this exception when I was trying to create a resultset with a lot of records in it , later I found the data set was so huge that even in PL/SQL it was showing memory issues.
Solution :
I had to restrict my query to be executed for a specific date range which user may select and warn the user about any possible issues when the date is very long.
I was facing this exception when I was trying to create a resultset with a lot of records in it , later I found the data set was so huge that even in PL/SQL it was showing memory issues.
Solution :
I had to restrict my query to be executed for a specific date range which user may select and warn the user about any possible issues when the date is very long.
No comments:
Post a Comment