Send Email of Dynamic Excel by Automation in Oracle APEX
declare l_highlights apex_data_export.t_highlights; l_context apex_exec.t_context; l_export apex_data_export.t_export; l_print_config apex_data_export.t_print_config; l_id NUMBER ; l_error_message cis_errors.ERROR_MESSAGE% type ; blob_content clob ; l_program_name varchar2 ( 250 ) := 'Automation :Premium Summary' ; begin l_context := apex_exec.open_query_context( p_location => apex_exec.c_location_local_db, p_sql_query => 'select rownum as "SR.NO", PR_LOCATION as "LOCATION", BR_NAME as "LOC NAME", THISYEAR_CMP_SALES as "THISYEAR_CMP_SALES", LASTYEAR_CMP_SALES as "LASTYEAR_CMP_SALES", THISYEAR_TP_SALES as "THISYEAR_TP_SALES" , LASTYEAR_TP_SALES as "LAS...