Re: BULK UPDATE with FORALL

From: Preston <dontwantany_at_nowhere.invalid>
Date: Sat, 01 Dec 2007 09:07:47 GMT
Message-ID: <Dv94j.499$Dh6.15@newsfe4-win.ntli.net>

Dereck L. Dietz wrote:

> Oracle 10.2.0.3, Windows Server 2003
>
> Can anybody explain to me why I'm getting an error stating that
> element at index does not exist with the code below? I'm using
> INDICES OF which I thought was supposed to take care of that.

INDICES OF will handle missing 'rows' in a collection (i.e. when you delete a row during a loop), but it won't take care of a missing (null) 'column'. The error message is telling you that one of the 'columns' (elements) doesn't exists in the row it's failing on.

-- 
Preston.

Received on Sat Dec 01 2007 - 03:07:47 CST