Hi,

Thanks.

This time also there is no luck. I went through the details of sys(3055) and even tried by setting to the maximum also. However this function can be used if the complexity level is high in WHERE or FOR clause. But in my case Select statement is having more columns and WHERE clause is very simple.

Here I would like to specify one more info. i.e. the systems on which I tried this are having 64 MB of RAM. Do you suspect short of memory for this.

Regards

Harish Sohani