Re: How can I run a procedural in scheduling?

• "Eric" <maw_at_tpts5.seed.net.tw>
  > Dear All:
  > I had a procedural need to run day by day? Had any way to solve it?
  > I had find a procedural dbms_aqadm.schedule_propagation. But when I Use
  > it,Oracle always had error message "dbms_aqadm.schedule_propagation Not
  > Declare!!".
  >
  > example:
  > EXECUTE dbms_aqadm.schedule_propagation( queue_name => 'BOLADM.test');
  >
  

Check out the DBMS_JOB package.

Terje Tysse Received on Mon May 21 2001 - 02:39:38 CDT