troubleshooting Question

TRIGGER for calling a stored procedure

Avatar of gotetioracle
gotetioracle asked on
Oracle DatabaseVMware
9 Comments2 Solutions665 ViewsLast Modified:
Hi,

I have table called data_process in this table there are there flags
1) Process 2) complete 3) error
If the user presses the process button then flag in the table updates to 'process' and a oracle job is called for every 30 min which calls a procedure and this procedure process the data and updates flag status as complete or error

The solution i am searching for is i want to trigger this procedure when ever user press the process button and i don't want to call it at application level i want to do this task at backend at database level without impacting the performance of database.

Note : data size is in TB and there are multiple users at multiple locations and does this task at a time.

Somebody help me

Regards,
GSK
ASKER CERTIFIED SOLUTION
mustaccio

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 9 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 9 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros