PL/SQL script to update table at specific time ?

[kmthien]

Hi Guys,

I am using Oracle9i Database. I would like to get a PL/SQL that will update a column (if it's NULL) in a table in a specific time. For example,

Table Name : User
Column Name : Logout

The procedure will be trigger at 2300 and check if 'Logout' is NULL and will update it. Please help !

Thanks and regards,
kmthien

 

[Buddha Bart]

I just busted out my "o'reilly oracle pl/sql programming" book and I can't find any mention of using time as a trigger.

I'm by no means an experienced pl/sql programmer though, so I could just not be looking in the right places (oh but I tried google and got nothing either).

Maybe you can solve this some other way, why are you logging out all your users at 11pm?

bart

 

[kmthien]

Hi,

This is because some operator forgot to logout sometimes and their shift have to be end by current date ! Pls help, Thanks !

kmthien

 

[Buddha Bart]

My natural inclination would be to stick a perl script in a cron job. Is this a *nix machine?

What if you set the default logout time to be 11:59:59 pm and then when people actually logged out, updated it to the real time?

bart