"php newbie" <newtophp2000@yahoo.com> wrote in message
news:124f428e.0405282010.7ffed5f5@posting.google.com...
> I am trying to write a cursor to update certain rows in a particular
> order as follows: (I need the cursor version, not SQL, as the update
> logic depends on the order of rows and some other conditions. I
> removed the Order-By clause from the statement to simplify it; it
> gives the same error message with or without it.)
>
> DECLARE prod_cursor CURSOR
> FORWARD_ONLY
> KEYSET
> FOR SELECT 1 FROM all_products WHERE p_qty = 0 FOR UPDATE
>
> This gives the following error message: "FOR UPDATE cannot be
> specified on a READ ONLY cursor."
>
> I have tried a few different combinations of cursor types (like SCROLL
> instead of FORWARD_ONLY) but they all give this error, although the
> statement seems identical to what I have seen in the books and in
> books online.
>
> Any ideas on how to convert this into an updating cursor?

> I am trying to write a cursor to update certain rows in a particular
> order as follows: (I need the cursor version, not SQL, as the update
> logic depends on the order of rows and some other conditions.

> DECLARE prod_cursor CURSOR
> FORWARD_ONLY
> KEYSET
> FOR SELECT 1 FROM all_products WHERE p_qty = 0 FOR UPDATE
>
> This gives the following error message: "FOR UPDATE cannot be
> specified on a READ ONLY cursor."
>
> I have tried a few different combinations of cursor types (like SCROLL
> instead of FORWARD_ONLY) but they all give this error, although the
> statement seems identical to what I have seen in the books and in
> books online.