I'm looking to create an invoicing procedure that executes automatically once a month. The procedure name is INVOICE_PROC.

I have tried to use a trigger to execute it but I can't get it to work. Would a trigger even be the best way to do this?

  • A trigger can do some action in response to some other action -- not what you need. You should look into dbms_scheduler. Apr 17 '19 at 19:15

Use Oracle's DBMS_SCHEDULER to schedule a job to run monthly.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.