06 Application Processes

[@fouad_alshamy]

شكرا لك صديقي فكرة جيدة ومفيدة

[@jeanchristianahikpa5561]

Thanks for the tip you shared..But I see that LOG_DATE is empty in the USER_LOG table after refreshing the other pages.

[@fouad_alshamy]

I think it's because he added a semicolon before (SYSDATE) and wrote it like this (:SYSDATE)

[@OrApex24]

Thank you for the nice note. It seems that I did not put the value correctly, but I will share with you the PL/SQL code when creating Application Processes.
begin
insert into USER_LOG (APP_USER,APP,PAGE,LOG_DATE)
VALUES
(:APP_USER,:APP_ID,:APP_PAGE_ID,SYSDATE);
end;

[@jeanchristianahikpa5561]

Exactly ​@@fouad_alshamy

[@jeanchristianahikpa5561]

Great ! ​@@OrApex24