Two things:

1. I implemented a unique primary key for the table and the error I was receiving on the Declare Cursor went away. You can't use FOR UPDATE without a unique primary key.

2. I implemented the code using a READ-ONLY cursor and doing my table updates directly to the table with a WHERE clause specifying the key value (since I already had it anyway). Seems to work pretty well.