How to UPDATE using ROWNUM and ORDER BY

I am trying to do the following:

EXEC SQL
UPDATE MY TABLE
SET COL1 = :newValue
WHERE COL1 = 0
AND ROWNUM = 1
ORDER BY COL2; (index on COL1, COL2)

Pro*C does not process the "ORDER BY" statement.

How can I achieve the above

Thanks
Sandra Received on Tue Aug 10 2004 - 09:43:29 CDT