There are two variables here: "FALSE" and the workspace ID. Off the top of my head, I'm guessing workspace ID can't be found where you are trying to do this. You say VM and Internal DB. Are these two different workspaces? Is this in the same workspace that where other execution of the code worked?
declare v_clob CLOB; begin v_clob := apex_040200.wwv_flow_utilities.export_workspace_to_clob ( p_workspace_id => 2626323717160271 , p_include_team_development => FALSE); end;
it is a real workspace ID, I checked it, doublechecked it and triplechecked it.Just to be sure, what I was trying to ask was: "It's a real workspace ID ... for THE workspace you are exporting from?"
More information can be found here: http://apexplained.wordpress.com/2012/03/20/workspace-application-and-page-export-in-plsql/
wwv_flow_api.set_security_group_id(2626323717160271); -- set the apex_application.g_user global variable... -- the username you use as argument needs admin privileges in the workspace apex_custom_auth.set_user('admin');
Actually this worked for me thanks for the link Nick!
declare l_clob CLOB; BEGIN wwv_flow_api.set_security_group_id(2626323717160271); apex_custom_auth.set_user('admin'); l_clob := wwv_flow_utilities.export_workspace_to_clob(p_workspace_id => 2626323717160271 , p_include_team_development => FALSE); end;