How to UPDATE using ROWNUM and ORDER BY

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 - 16:43:29 CEST