Hello,
i am on Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production installed on Windows7 64 bits.
i created jobs which run one procedure with one argument as follows:
dbms_scheduler.create_job(
job_name => lv_job_name,
job_action => 'name of a packaged procedure',
job_type => 'STORED_PROCEDURE',
repeat_interval => lv_REPEAT_INTERVAL,
start_date => ld_START_DATE,
end_date => ld_END_DATE,
number_of_arguments => 1,
job_class => 'my_JOB_CLASS',
auto_drop => false);
dbms_scheduler.set_job_argument_value(
job_name => lv_job_name
,argument_position => 1
,argument_value => ln_trig_id
);
when i run it with use_current_session set to true, everything works fine, i get expected results.
otherwise, the job is successful nut it returns nothing (as if the stored procedure was not executed).
when i see scheduled run times, they are right, when i see logs, the runs are successfull but alwas as if stored procedure was not executed.
any idea of what it could cause this issue would be appreciated. thanks in advance