dcsimg
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Can anybody help please.....

  1. #1
    Join Date
    May 2001
    Location
    Bangalore,India.
    Posts
    5

    Question

    Hi,
    Can anybody tell me whether an time based database trigger be written.
    Is it possible...what i want to know is that
    If i have one table with fields (say)id,date,flag.Initially flag is set to N.Now is it possible to write a database trigger which fires every 1 hour and what it does is that it checks the date field---(date+7) >sysdate then it erases the id filed of that row and then sets the flag field to Y in that row.It checks for each row...in this way.
    This is not to be related with the insert/update/delete actions in that table.What ever DML operations are done it does not fires this trigger..this trigger should fire for every 1 hour on its own and check the status.......
    Please tell me whether this kind of time based database trigger is possible or not..if yes then how it can be done.

    Thanking u in advance
    Ram

  2. #2
    Join Date
    Feb 2001
    Location
    Kolkata- India
    Posts
    356

    Thumbs up

    hi Ram!
    I guess you cannot do it through triggers. You can schedule triggers and you cannot fire a commit from a trigger. What you can do is write a package which does the updation and commits it. Then schedule the package to fire by using dbms_job package. Please go through Oracle help the exact syntax on dbms_job package.
    Regards
    Sudip
    There Nothing You cannot Do, The problem is HOW.

  3. #3
    Join Date
    Feb 2001
    Location
    Kolkata- India
    Posts
    356
    hi Ram!
    Sorry I made a mistage in the last post.
    the change is in caps this time. Sorry


    I guess you cannot do it through triggers. You CANNOT schedule triggers and you cannot fire a commit from a trigger. What you can do is write a package which does the updation and commits it. Then schedule the package to fire by using dbms_job package. Please go through Oracle help the exact syntax on dbms_job package.
    Regards
    Sudip
    There Nothing You cannot Do, The problem is HOW.

  4. #4
    Join Date
    May 2001
    Location
    Bangalore,India.
    Posts
    5
    thanks Sudip for the help
    Now atleast i have a direction in which i can proceed to get this job done....
    Thank you very much.
    Ram

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width