checking for No Data Returned 1

[CIMTEET]

I am running a FOR loop

For I IN c_id_map.first..c_id_map.last loop

There is data retrieved from the c_id_map table structure that is declared in this structure. Not actually in the Schema. So it works as a user defined type does in other languages. There are only 2 records to be looked at but this loop looks a third time in which I return an oracle 01403 : no data found. I understand why it gets this I don't know why it goes through a third time based on the syntax. I can encase my data in an IF statement checking for No Data or Null, I just wasn't quite sure what to look for. If I don't catch it before the third pass then my exception takes over. Help

Greg

 

[LKBrwnDBA]

Try:

For I IN c_id_map.first..c_id_map.[red][b]COUNT[/b][/red] loop

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb