Home/ Questions/Q 4863
In Process

vinish.ai Latest Questions

  • 0
  • 0
Asked: 2020-07-18T14:02:38+00:00

Subscription Option In Oracle apex

  • 0
  • 0

Hi Team,

In Oracle apex in report section we have an option subscription, by which user can customize report grid and create schedule to receive that report through email as per schedule.
I have 2 question related to subscription

  1. Instead of .htm format can user get the report in .csv format using subscription.
  2. Now a days users are getting blank report in email, however same report I am able to get using download option. Please let me know if you require more details
apexoracle apexoracleapex.
Share
Leave an answer

Leave an answer

Browse

1 Answer

  1. Hi Ram,

    You can download a CSV directly from the interactive report using the following syntax:

    f?p=&APP_ID.:10:&SESSION.:CSV:NO:RP:P10_EMPID:&P3_EMPLOYEE_ID.

    In the above example, it will call the report, which is on page number 10, by passing the CSV parameter after the session variable. Also, passing the report parameters employee id. You can omit this if not required. For the full tutorial, check this link Download CSV from Interactive Report using URL.

    Another way is you can write a database procedure to extract the data into a CSV file.

    Check this link Download CSV using PL/SQL procedure.