How to call oracle dbms_scheduler.run_job from java?
<p>I have a job in my oracle database and for some reason i need to call it within my java application.<br />
Anyone has an idea to tell me how?<br />
I already tried:<br />
<strong>execute DBMS_SCHEDULER.RUN_JOB('My_job_name')<br />
DBMS_SCHEDULER.RUN_JOB('My_job_name')<br />
{DBMS_SCHEDULER.RUN_JOB('My_job_name')}<br />
{execute DBMS_SCHEDULER.RUN_JOB('My_job_name')}<br /></strong>
by <strong>CallableStatement</strong> but none of them worked.
<br />
Any help would be appreciated </p>