handle huge number of rows in data block [message #511758] |
Tue, 14 June 2011 23:01 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
sethumurugan
Messages: 61 Registered: June 2010 Location: Chennai
|
Member |
|
|
Hi,
I have a situation where I need to read a huge number of rows, say in lakhs and then need to populate it in data block.
Since it is having huge data am never able to run the form. it hangs after some time. when i test with few rows it is working. so no problem in coding.
Can any one suggest a method how to handl this situation?
|
|
|
|
Re: handle huge number of rows in data block [message #511780 is a reply to message #511774] |
Wed, 15 June 2011 01:58 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
sethumurugan
Messages: 61 Registered: June 2010 Location: Chennai
|
Member |
|
|
actually we need to display the list of part numbers required to produce a truck. we have provided a report also. but the user department requires to be displayed in form.
this problem has been solved by converting the block in DB block
thanks
|
|
|
|
|