creating reminders

[tyb]

dear frends

i have an action calender table and i want to put reminders for these actions on the date in the calender table.

i think it can be done in this way using an sql query

select cal_id
from cal
where cal_val1 = truncate(sysdate)
or cal_val2 = truncate(sysdate)
or cal_val3 = truncate(sysdate);

1. can any body tell me if it can be done through pl-sql in some simple way (something like "IN") instead of using much " OR " (as i have 40 date columns in this table).

2. how can i make the reports run against these multiple values retrieved by the query, can it be done using data parameter as it stores an array.


plz help, its most urgent

 

[HimanB]

Hi,
You can make a PL/SQL procedure and Schedule the job to run daily using DBMS_JOB package.
If the dates match with Sysdate then the Procedure may execute the required Procedure or report or program.

HTH
Regards
Himanshu

 

[tyb]

Thanks Himanshu

can u plz explain it with a small example as i navr used these packages so i'm unable to get an start with it.
plz help me getting a clue to do it.

2ndly if i perform this task only by using
" where cal_val1 = truncate(sysdate)+2 "
to show it two days earliar it will be shown only two days earliar and wouldnt generate continuous reminders untill the date.

plz help me.

thanx & regards