SQL & PL/SQL

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!

Oracle 7i

610973Jan 16 2008 — edited Jan 17 2008

Hello friends,
I using Oracle 7i, I want to run dbms_job
I am able to set date format by using
SQL>alter session set nls_date_format='dd-mon-yyyy hh24:mi:ss';
but I unable to set job_queue_processes by using
SQL>alter system set job_queue_processes=2;
or
SQL>alter session set job_queue_processes=2;

It gives error
ORA-02095: specified initialization parameter cannot be modified
how to resolve same?

Is DBMS_JOB compactible to Oracle 7i?
please help me

Avinash Deokar

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 14 2008

Added on Jan 16 2008

19 comments

1,818 views