Hi,
I’m trying to update a date the latest_start field based on the change of planned_finish by an event server but with no success.
Inside the application. Using PL/SQL it works well runing the code manually
Could someone help please?
Follow the code:
DECLARE
p1_ DATE;
BEGIN
SELECT PLANNED_FINISH
INTO p1_
FROM jt_task_uiv
WHERE TASK_SEQ = &OLD:TASK_SEQ;
UPDATE jt_task_tab
SET LATEST_START = p1_
WHERE TASK_SEQ = &OLD:TASK_SEQ;
commit;
end;
Best answer by lopespetro
View original