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 ;
