Hi all,
My need is to modify trigger in order to read updated value in columns COL1, COL2 from table scheme1.table1 and pass them into packaged procedure scheme1.PKG_A.prepare1 when one-time job starts.
How do I perform it?
declare
vJobNumber binary_integer;
BEGIN
dbms_job.submit(
job => vJobNumber,
next_date => SYSDATE,
interval => NULL,
what => 'begin scheme1.PKG_A.prepare1; end;'
);
commit;
END;
/