Monday, September 25, 2017

workspace export in sqldeveloper with apex 3.2.1 runtime

From sqldeveloper you can export the workspace in a runtime environment in apex 3.2.
Just did a trace in our DVL environment, this was executed.
In sqldeveloper just put in the code , activate OWA output from view -> owa output :


NOTE replace :WORKSPACE with your workspace.


declare
  l_orig_sgid number := wwv_flow_security.g_security_group_id;
begin
  for c1 in (select provisioning_company_id
    from wwv_flow_companies
    where short_name = upper(':WORKSPACE')) loop
    wwv_flow_security.g_security_group_id := c1.provisioning_company_id;
  end loop;
  --
--  htp.init;
  wwv_flow.g_page_text_generated := true;
  wwv_flow_fnd_user_api.g_mime_shown := true;
  owa_util.mime_header('application/x-sql',false);
  htp.p('Content-Disposition: attachment; filename='|| wwv_flow_utilities.escape_url(p_url => ':WORKSPACE', p_url_charset => 'utf-8') ||'.sql');
  owa_util.http_header_close;
  --
  wwv_flow_fnd_user_api.export_fnd_users(p_export_format=>'UNIX');
  --
  wwv_flow.g_page_text_generated := true;
  wwv_flow.g_unrecoverable_error := true;
  wwv_flow_security.g_security_group_id := l_orig_sgid;
  --
exception when others then
  wwv_flow_security.g_security_group_id := l_orig_sgid;
  raise;
end;
/


Select 'greetings from dik pater ' from dual ;