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