Hi
My requirement is there is procedure should be executed based on the date
which is configured in a table.
For example,. There is a table tbl_config
CREATE TABLE TBL_CONFIG (config_name VARCHAR2(15), job_run_date DATE);
INSERT INTO TBL_CONFIG VALUES ('JOB100', TO_DATE('30-MAR-2009
02:00:00','DD-MON-YYYY HH24:MI:SS'));
The below example procedures needs to be executed based on the date time
which is configured in the tbl_config. User has rights to set the different
date on the config table.
CREATE OR REPLACE PROCEDURE PROC_UPDATE_STATUS
IS
BEGIN
UPDATE tbl_time_sheet SET status = 'I' WHERE status <> 'I';
END;
Thanks in Advance
Deen
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
-~----------~----~----~----~------~----~------~--~---
