large delete

From: Akimeu <Nospam_at_Email.com>
Date: Tue, 20 Jun 2006 16:21:27 -0700
Message-ID: <lo%lg.10061$FR1.3378@dukeread05>

hello,

i have done some looking around for this, but haven't really found a solid answer. we have an sp, to which we're passing in a table name, after which we execute immediate a delete statement. is there any way of committing within this particular delete?

any insights/suggestions are appreciated. thanks.

this is what i was thinking of doing:

   loop

   	  vsql:='delete from '||vschem||'.'||vtablename||
         	 ' where '||vcol||'='''||vid||''' and rownum <= 10000';
  	  execute immediate vsql;
	  exit when sql%rowcount = 0;
	  commit;

   end loop; Received on Tue Jun 20 2006 - 18:21:27 CDT