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

Answered by: Chris Saxon - Last updated: July 27, 2020 - 4:05 pm UTC

Category: Application Express - Version: 20.1.0.00.13

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 we 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.

and you rated our response

  (1 rating)

Reviews

More detail to my question about stored report on database

July 27, 2020 - 1:38 am UTC

Reviewer: Huy Nguyen

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

Followup  

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 to Explore

APEX

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