Re: dbms_job and setting the interval

From: Vsevolod Afanassiev <vafanassiev_at_aapt.com.au>
Date: 15 Oct 2001 20:49:51 -0700
Message-ID: <4f7d504c.0110151949.136ee909@posting.google.com>

What exactly do you mean? Yes, you can use variable in PL/SQL block where you call DBMS_JOB.SUBMIT, but it must have a value! Basically, just use your own example and remove word CONSTANT. Or I misunderstood he question?

Regards,
Sev

vafanassiev_at_aapt.com.au

sgelberg_at_optonline.net (Seth) wrote in message news:<f3159b28.0110151501.795ccb23_at_posting.google.com>...
> Can you specify a variable to use as the interval value in the
> dbms_job.submit:
>
> for ex:
>
> v_matchInterval CONSTANT NUMBER := 10/86400; -- 10 Seconds
> .
> .
> .
> DBMS_JOB.SUBMIT(jobno, 'matching.matchfacade;', sysdate, sysdate +
> v_matchInterval);
Received on Mon Oct 15 2001 - 22:49:51 CDT