SQL stored procedures:
create or replace procedure job_proc is
begin
--Free tickets to modify modify ID
Update O_2413 set 'where attr_24131004=' attr_24131004=' void sold ';
--Single: modify modify ID
Update O_2405 set 'where attr_24051004=' attr_24051004=' void sold ';
Corporate voting--modify modify ID
Update O_2412 set 'where attr_24121004=' attr_24121004=' void sold ';
end;
The SQL job:
declare
job number;
begin
dbms_job.submit(job, 'job_proc;', sysdate, 'TRUNC(SYSDATE + 1)');
end;