Sergey

Thanks for the information, I built this around an example in a book, maybe it is a little old. I'm using the cursor in a few stored procedures and haven't ever had it return a -1 that is what got me confused. I think I look at modifing them to refect the fetch_status as in your example.

Thanks again

Kirk