How can I perform such SQL in Oracle:

Pseudo

EXEC SQL
UPDATE MYTABLE
SET STATUS = :s
WHERE STATUS = 0
AND ROWNUM = 1
ORDER BY TIME;

Pro*C does not like the order by statement.

Thanks
Sandra