Re: parametrized programs in chains in 10g

From: Remigiusz Sokołowski <rems_at_wp-sa.pl>
Date: Fri, 01 Sep 2006 12:40:39 +0200
Message-id: <44F80E27.8000708@wp-sa.pl>

rjamya wrote:

> http://download-east.oracle.com/docs/cd/B14117_01/appdev.101/b10802/d_sched.htm#1010949

It works of course, but only for a job running program and not for a chain of programs

Usage of procedure
DBMS_SCHEDULER.SET_JOB_ARGUMENT_VALUE (

   job_name      =>'J_EXP_IMP_TEST', -- running EXP_IMP_CHAIN
   argument_name =>'V_CONNECT_CREDENTIALS',
   argument_value=>'test/test_at_poligon.world');

doesn't help - setting variables by name returns error ORA-27475: "TEST.EXP_IMP_CHAIN" must be a program in this case

Any other thoughts? Of course it is also possible that the scheduler fascility is not mature enough to provide comprehensive solution

Remigiusz

-- 
---------------------------------------
Remigiusz Sokolowski <rems_at_wp-sa.pl>
WP/PTI/DIP/ZAB (+04858) 52 15 770
---------------------------------------

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Sep 01 2006 - 05:40:39 CDT