Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

wwv_flow_utilities.export_workspace_to_clob

Joni VandenbergheApr 8 2013 — edited Apr 9 2013
Hi,

I have the VM from the oracle Developer days. The only thing that is different is that APEX is upgraded to 4.2.

When I execute this piece of code:
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;

I get an error:
Error report:
ORA-06502: PL/SQL: numeric or value error: NULL index table key value
ORA-06512: at "APEX_040200.WWV_FLOW_SECURITY", line 645
ORA-06512: at "APEX_040200.WWV_FLOW_FND_USER_API", line 138
ORA-06512: at "APEX_040200.WWV_FLOW_FND_USER_API", line 289
ORA-06512: at "APEX_040200.WWV_FLOW_UTILITIES", line 10051
ORA-06512: at "APEX_040200.WWV_FLOW_UTILITIES", line 10075


I am able to execute the same procedure on an internal DB withouth problems. Any idea why it would fail here? And the number 2626323717160271, is the id from a workspace, just so you know :-)
This post has been answered by Nick Buytaert on Apr 9 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 7 2013
Added on Apr 8 2013
6 comments
1,018 views