On Mar 26, 8:06 am, Oracle Deen <[email protected]> wrote:
> Hi
>
> My requirement is there is procedure should be executed based on the date
> which is configured in a table.
>
Why? This is precisely thr functionality of DBMS_SCHEDULER which
you're trying, poorly, to duplicate.
> 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.
>
This is still a poor substitute for DBMS_SCHEDULER.
> CREATE OR REPLACE PROCEDURE PROC_UPDATE_STATUS
> IS
> BEGIN
> UPDATE tbl_time_sheet SET status = 'I' WHERE status <> 'I';
> END;
>
> Thanks in Advance
> Deen
Use the tools Oracle provides as they are more robust.
David Fitzjarrell
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
