Seeking assistance, how to generate report using the below code,
Can we use beloe code to automate report generation ?
DECLARE
l_document blob;
BEGIN
l_document :=
apex_print.generate_document (
p_application_id => 100,
p_report_query_static_id => 'MY_REPORT_QUERY',
p_report_layout_static_id => 'MY_REPORT_LAYOUT',
p_output_type => apex_print.c_output_pdf );
apex_http.download(
p_blob => l_document,
p_content_type => 'application/pdf',
p_filename => 'my-report.pdf' );
END;