If you want to chanhe order by clause you must down and reopen the cursor. May be you don't use order by clause and you can use local indexes so your users can be change order...