Hi Mladen, A some time ago I found that 10g is boosting some simple PL/SQL code. I went into and find out this functionality about prefetching (bulk fetches). The discussion + some code you can find on asktom.oracle.com. Regards, Zoran --- Mladen Gogala <gogala@xxxxxxxxxxxxx> wrote: > In a recent article to comp.databases.oracle.server > Connor McDonald > hinted that Oracle 10g does automatic bulk loads for > "cursor for =20 > loops", if coded properly. I wasn't able to find > anything about it. > Does anybody here know what Connor is talking about? > A pointer to > an article or an example, maybe? > > --=20 > Mladen Gogala > Oracle DBA > __________________________________ Do you Yahoo!? Yahoo! Mail - You care about security. So do we. http://promotions.yahoo.com/new_mail -- //www.freelists.org/webpage/oracle-l