apex_plsql_job - Submitting jobs to run in background
sriniFeb 25 2009 — edited Feb 25 2009Hi all,
I am trying to run a process that takes a long time as a PL/SQL background process. I learnt that 'apex_plsql_job' helps us do this. But I couldn't find any example on how this is to be used:
My process presently runs the below PL/SQL code:
#OWNER#.GET_PATCH_DEPENDENCIES(
P_BUG_NO => :P3_BUG_NO,
P_RECURSE_YN => :P3_RECURSE_YN,
P_BASE_PATCH_NO => :P3_BASE_PATCH_NO,
P_CODELINE_PATCH_NO => :P3_CODELINE_PATCH_NO,
P_PRODUCT_CODE => :P3_PRODUCT_CODE,
X_SEQ => :P3_SEQ);
How do I change this to run as an Apex background job? I tried calling
apex_plsql_job.submit_process() with the above PL/SQL code. I was able to see an entry in APEX_PLSQL_JOBS. But my PL/SQL code has not run.
Is there someway to debug or any pointers to some working code using this APEX_PLSQL_JOBS Api?
Thanks in advance,
Srini