Oracle APEX - DML Inside Procedure || Insert || Update || Delete

[@ohenesekyi9877]

good job very straight forward

[@gasparmartinez2782]

Thanks man. It really helped.
But how exactly do you call a procedure without a button? Like after creating a new register.

[@farisiraqi8375]

CAN YOU HELP FOR MY PROCEDURE TO UPDATE TUBLE USERS FAELID ACTIVE_NOW FROM 1 TO 0 WHEN THE WEB SINGOUT OR CLOSE PAGE
THIS PROCEDURE DONOT WORG IN ORACLE APEX

[@farisiraqi8375]

I need to run the processor in this place -- Authentication Scheme -Post Logout Procedure Name

[@farisiraqi8375]

create or replace PROCEDURE update_user_active_now(P_USERNAME IN VARCHAR2)
IS
BEGIN
UPDATE usernamer
SET active_now = 0
WHERE log_in = P_USERNAME;
COMMIT;
END;