ERPstuff - Oracle EBS Community

DECLARE
l_context apex_exec.t_context;
l_export apex_data_export.t_export;
BEGIN
l_context := apex_exec.open_query_context(
p_location => apex_exec.c_location_local_db,
p_sql_query => 'select * from emp' );

l_export := apex_data_export.export (
p_context => l_context,
p_format => apex_data_export.c_format_pdf );

apex_exec.close( l_context );

apex_data_export.download( p_export => l_export );

EXCEPTION
when others THEN
apex_exec.close( l_context );
raise;
END;

Export format. Valid values are: XLSX, PDF, HTML, CSV, XML and JSON.

https://docs.oracle.com/en/database/ora ... 554B19EC8E