Hi
I am trying use apex_data_export for create PDF file that contents HEBREW words
But all Hebrew words in the file appearance as GEBRISH
these is a my PLSQL code for file creating:
declare
cursor c_apex_app is
select ws.workspace_id, ws.workspace, app.application_id, app.page_id
from apex_application_pages app, apex_workspaces ws
WHERE ws.workspace = app.workspace
AND ws.workspace = 'HR WS' AND app.page_id = 1
order by page_id;
v_apex_app c_apex_app%rowtype;
v_stmnt varchar2(32000);
v_context apex_exec.t_context;
v_export apex_data_export.t_export;
begin
dbms_output.put_line('Getting app details...');
-- We only need the first record returned by this cursor
open c_apex_app;
fetch c_apex_app into v_apex_app;
close c_apex_app;
apex_util.set_workspace(v_apex_app.workspace);
dbms_output.put_line('Creating session');
apex_session.create_session
(
p_app_id => v_apex_app.application_id,
p_page_id => v_apex_app.page_id,
p_username => 'alexk' -- this parameter is mandatory but can be any string apparently
);
v_stmnt := 'SELECT ho.name organiztion_name, ho.organization_id FROM hr_all_organization_units ho WHERE ROWNUM <10';
v_context := apex_exec.open_query_context(
p_location => apex_exec.c_location_local_db,
p_sql_query => v_stmnt
);
v_export := apex_data_export.export (
p_context => v_context,
p_format => apex_data_export.c_format_pdf );
apex_exec.close( v_context);
PEL_FTP.Put_Local_Binary_Data(p_Data => v_export.content_blob,
p_Dir => 'PEL_TMP_DIR',
p_File => 'FILE.pdf');
-- apex_data_export.download( p_export => v_export );
EXCEPTION
when others THEN
apex_exec.close( v_context );
raise;
end;
Can you help me?
Regards
Alexander