Skip to Main Content
  • Questions

  • Storing and Accessing Reports in the Database on oracle Apex of version 20

Breadcrumb

Question and Answer

Chris Saxon

Thanks for the question, Huy.

Asked: July 20, 2020 - 4:41 am UTC

Last updated: July 27, 2020 - 4:05 pm UTC

Version: 20.1.0.00.13

Viewed 100+ times

You Asked

I have a problem in Storing and Accessing Reports in the Database on oracle apex of version 20. I do not use AOP. And I find out on GG and have a guide about this of version 3.0 below as:

https://www.oracle.com/ocom/groups/public/@otn/documents/webcontent/228193.htm

I want to store multi report on database. But I try my best to follow the guide but it have been unsuccessfully. When I pressed Print button, it just only downloaded multi report but on database it was not stored. Can anyone solve for me? Thank you in advance.

and Chris said...

I'm unclear what exactly you mean by store multi report on database - what exactly are you trying to do here?

In any case I suggest looking at the 20c version of the documentation 3.0 is years old now!

These links may help:

https://docs.oracle.com/en/database/oracle/application-express/20.1/htmdb/printing-report-regions.html#GUID-DC71D83B-7D7A-484A-BBD7-06625702E34C
https://docs.oracle.com/en/database/oracle/application-express/20.1/htmdb/understanding-blob-support-in-forms.html#GUID-206633B5-F761-4CCB-AE71-2CF8539B482E

I can see you've asked this on a number of other forums with no response. Try updating one of those questions with more details about what exactly you're doing.

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

More detail to my question about stored report on database

Huy Nguyen, July 27, 2020 - 1:38 am UTC

Thank you for your response. My fault is explaining my problem. I try to when I run report query, it will be automatically stored on database that I created.
On guide of version 3.0. I saw the workflow I would like to follow. In practical, when press print report query, it would be inserted row on Report Archived table. I processed it but it only downloaded and for storing it was not run.

In summary, I would like to run a report query and automatically inserted name, file, format of that report on database I created. Thank you for helping me ^_^
Chris Saxon
July 27, 2020 - 4:05 pm UTC

It's still not clear exactly what you've tried doing.

Please ask a new question describing the actions you took and showing the code you've used
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

APEX

Keep your APEX skills fresh by attending their regular Office Hours sessions.