Skip to Main Content

Database Software

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!

why do dbms_scheduler.run_job get nothing when use_current_session set to false

2816188Mar 23 2015 — edited Mar 24 2015

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

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 21 2015
Added on Mar 23 2015
10 comments
3,869 views