Hi
I wanna change query in runtime environment in developer/2000 reports with a button through DO_SQL .

My report depend on
select * from user;

Pl/Sql code for button
Example

Procedure U_1ButtonAction is
begin
SRW.DO_SQL('SELECT * FROM USER
0REDR BY USER_NAME');
EXCEPTION
WHEN SRW.DO_SQL_FAILURE THEN
SRW.MESSAGE(100, 'ERROR WHILE CHANGING ORDER.');
RAISE SRW.PROGRAM_ABORT;
END;

In above procedure there was an error or any change plz write
or
write an example.
Thanx