Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Trigger or Oracle Job

Sreejith_NairFeb 2 2010 — edited Feb 4 2010

Hi Friends,
I need a suggestion in the best practice that can be used for the following scenario.
I have a table which gets populated by a process,not very frequently.Once entry comes to this table,I have to do some data operation based on this table data.
I can wait for this processing by may be next half an hour.

Please advice on whether I should use a trigger and a stored procedure / go for an oracle scheduled job which runs every 30 Mins and listen this table and calls a stored procedure to do the data manipulation.

Many Thanks,
SSN

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 4 2010

Added on Feb 2 2010

#general-database-discussions

5 comments

1,179 views