I'm working on a new database ..... in Oracle 8 I need to create a
procedure or function that will automatilly assign tasks each week for
people to work... the task are stored in a table ... tblsTasks


Name Null? Type
------------------------------- -------- ----
TXTTASK NOT NULL VARCHAR2(255)
TXTTYPE NOT NULL VARCHAR2(20)
TXTDOCNAME VARCHAR2(25)
BCLEANMAINT NUMBER(1)

The scheduales are in another table tblScheduales

Name Null? Type
------------------------------- -------- ----
INTCOUNTER NOT NULL NUMBER(11)
SLLINKID NUMBER(11)
TXTITEM NOT NULL VARCHAR2(25)
DATESTART NOT NULL DATE
TXTTIME NOT NULL NUMBER(5)
TXTTASK NOT NULL VARCHAR2(255)
SCHEDCOMMENTS VARCHAR2(100)
CHKSATURDAY NUMBER(5)
TXTASSIGNEDTO VARCHAR2(50)
INTPRIORITY NUMBER(11)
CHKFIXDATE NUMBER(1)

I need a procedure or a function that will display new work orders for
each week and If the task isn't done ... it will be assigned next week


Here is a few semples of the data in tblShedules ..

SQL> select * from tblSchedules;

INTCOUNTER SLLINKID TXTITEM DATESTART TXTTIME
---------- --------- ------------------------- --------- ---------
TXTTASK
----------------------------------------------------------------------------------------------------
SCHEDCOMMENTS
----------------------------------------------------------------------------------------------------
CHKSATURDAY TXTASSIGNEDTO
INTPRIORITY CHKFIXDATE
----------- --------------------------------------------------
----------- ----------
87 327 FE1 26-MAY-03 4
Inspect
Outside lunchroom
1 H&S Rep.
1 0

88 328 FE2 26-MAY-03 4
Inspect
Front lobby
1 H&S Rep.
1 0

89 329 FE3 26-MAY-03 4
Inspect

1 H&S Rep.
1 0


Any Idea how can I do this ..... Thanx