DevOps, CI/CD and Automation

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!

Call reports from pl/sql without forms?

562936Feb 20 2007 — edited Jul 23 2007

Is there any way to call the reports server using pl/sql without the requirement of forms?
I've seen the threads on web.show_document and run_reports_object, but from what I can see these are forms only functions, which we don't use.

We would like to set up a trigger in the db which would generate (using reports) and email a pdf when certain conditions/event occur, without requiring the user to click on a "Email PDF" button/link in apex.

This could also be useful in hiding the dynamic values in the URL that we cannot hide with the cgicmd.dat file.

If I'm missing anything please let me know, I'm not an oracle dba by trade so most of this is fairly new to me.
Thanks!