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 5.1 running scheduler job (python script)

3369650Dec 30 2017 — edited Jan 1 2018

Hello

I am able to run following job when I don't add argument to python script and I know page item (:P13_ID) has value set (displayed), can somebody help how to pass variable to scheduler ?

from log I am seeing variable name itself not variable content.

working when I give hard coded value in the place of bind variable.

BEGIN

DBMS_SCHEDULER.CREATE_JOB (

     job_name           => 'SendAdhocemail',

     job_type           => 'EXECUTABLE',

     job_action         =>'python Send_Adhocemails.py :P13_ID ',

     enabled              =>  TRUE

     );

END;

Thanks

A

This post has been answered by fac586 on Dec 31 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 29 2018
Added on Dec 30 2017
3 comments
881 views