CREATE OR REPLACE procedure SKEMAIN.clearDownUserX( userName users.LOGINNAME%type)asbegin-- all active cancel requested or requested orders set to cancelled and inactive. update orders set active = 0, stateId = 7 where traderUserId in (SELECT ID FROM users WHERE LOGINNAME = clearDownUserX.userName) and active = 1 and stateId in (3, 9);-- all active orders set to inactive. update orders set active = 0 where traderUserId in (SELECT ID FROM users WHERE LOGINNAME = clearDownUserX.userName) and active = 1; commit;end clearDownUserX;/