APEX

Has anyone got APEX_PLSQL_JOB.SUBMIT_PROCESS to work? I've seen several threads which my exact problem but am unsure if anyone has got it to work.

Here is my process:

declare
  jobnumber number;
begin
IF apex_plsql_job.jobs_are_enabled THEN
    jobnumber := apex_plsql_job.submit_process(
          p_sql => 'insert into temp_jobtest 
                    values (''APEX PLSQL Job'',sysdate);  
                    commit;');
END IF;
end;

Process runs and APEX_PLSQL_JOBS shows SYSTEM_STATUS as "COMPLETE" but no rows are ever added to the temp_jobtest table. I tried submitting directly using dbms_job and it worked as expected.

I have read: 1225941

I really wish we could still create a process type of (PLSQL DBMS JOB). If this functionality has been deprecated then why is it still referenced in the User Guide?

From the APEX User Guide, Release 2.2, B28550-01, July 2006; page 13-15; heading - "Using a Process to Implement Background PL/SQL"

The simplest way to implement the APEX_PLSQL_JOB package is to create a page
process that specifies the process type PLSQL DBMS JOB. By selecting this process
type, Application Builder will submit the PL/SQL code you specify as a job.