SQL%ROWCOUNT in an implicit cursor.

hi there,

I need to make a commit every 20 records, the cursor i have which is an implicit one, looks like this:

for C in (

    select * from Y)
loop (

    insert into Z
)
IF record_inserted = 20

    commit;
End If;

How do I code the record_inserted section??? SQL%ROWCOUNT only returns the total number of records in the implicit cursor right?

Thanks !!!
Gojo. Received on Fri Jun 02 2000 - 00:00:00 CDT