Data Export Function Sample PL_SQL

Oracle Application Express is a rapid development tool for Web applications on the Oracle database.
Post Reply
admin
Posts: 2062
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

Data Export Function Sample PL_SQL

Post by admin »

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
Malik Sikandar Hayat
admin@erpstuff.com
Post Reply

Who is online

Users browsing this forum: No registered users and 4 guests