Delete all rows in ViewObject
a.gruevAug 5 2010 — edited Mar 14 2012Hi, I'm using JDev 11.1.1.2
I have search the forum and the i-net and I reach the conclusion that in ADF you cannot perform multiple row delete in a single db call.
It seems natural form the that the ViewObject provides a method i.e. "deleteAllRows()" ... so I can set some filter criteria on my VO and then call removeAllRows() ...
The example I found so far are:
while (vo.hasNext()) { vo.remove(); }
which is highly undesirable when one wants to delete thousands of rows.
So is it my only choice left to use preparedStatement with SQL ... ?
Thanks
agruev