Hi!

I have a problem with downloading XLIFF file for whole application (Shared Components\Translate\XLIFF Export). It looks the request timeouts after 5 minutes ("Failed to load resource: the server responded with a status of 500 (Internal Server Error)").

The application is quite big, with several hundred of pages. For single page it works, but not all translations are page specific (some are not assigned to any page).

I tried to somehow get this file on database level. There is a package wwv_flow_xliff (schema apex_200200) with function & procedure get_translation_document.

function get_translation_document(
    p_flow_id             in number,
    p_page_id             in number default null,
    p_translation_flow_id in number,
    p_include_target      in varchar2 default 'N',
    p_include_all         in varchar2 default 'N',
    p_item_help           in varchar2 default null )
return blob;

It looks promising, but it fails ("PL/SQL: numeric or value error%s") when I try to run it like this:

declare
xliff_file  blob;
begin
    xliff_file := apex_200200.wwv_flow_xliff.get_translation_document(
        p_flow_id => 500,
        p_translation_flow_id => 502
    );

end;

The same happens when specific page_id is provided.

Is there a way to get this working either from web or using this package? The latter solution would be just fine if the timeout issue cannot be resolved easily.

I also tried to manually generate this file from translation tables [wwv_flow_translatable_text$; wwv_flow_messages$; wwv_flow_dynamic_translations$, etc.], but these are all workarounds with next problems like xml escape characters...

For all that, APEX gives a legit way to export this file.
I will appreciate your help a lot! 😊
Thanks in advance.

SQL> declare
  2  nm owa.vc_arr;
  3  vl owa.vc_arr;
  4  begin
  5  nm(1) := 'REMOTE_ADDR';
  6  vl(1) := '1.2.3.4';
  7  owa.init_cgi_env( nm.count, nm, vl );
  8  end;
  9  /

PL/SQL procedure successfully completed.

SQL>
SQL>
SQL> declare
  2    xliff_file  blob;
  3  begin
  4    dbms_lob.createtemporary(xliff_file ,true);
  5      xliff_file := apex_210200.wwv_flow_xliff.get_translation_document(
  6          p_flow_id => 100,
  7          p_translation_flow_id => 502
  8      );
  9
 10  end;
 11  /

PL/SQL procedure successfully completed.