Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

apex_plsql_job - Submitting jobs to run in background

sriniFeb 25 2009 — edited Feb 25 2009
Hi 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 25 2009
Added on Feb 25 2009
1 comment
505 views