This discussion is archived
4 Replies Latest reply: Oct 23, 2012 8:15 AM by Hilary RSS

Cannot install Sample Master Detail (Packaged Application)

RickyBurke Newbie
Currently Being Moderated
When trying to install the Sample Master Detail packaged application
on the new APEX.Oracle.com (running Application Express 4.2.0.00.22),
I'm getting an error.

After selecting it from the Packaged Applications page, and clicking the "Install Application" button
on the Application Builder/Packaged Applications/Sample Master Detail/Install screen,
I get the following:

--------
Execution of the statement was unsuccessful. ORA-00001: unique constraint (APEX_040200.WWV_FLOW_MESSAGES_IDX1) violated

declare
h varchar2(32767) := null;

begin

h:=h||'Help';

wwv_flow_api.create_message (
p_id=>2456294651379654494 + wwv_flow_api.g_id_offset,
p_flow_id=>wwv_flow.g_flow_id,
p_name=>'HELP',
p_message_language=>'en',
p_message_text=>h);
null;

end;

ORA-00001: unique constraint (APEX_040200.WWV_FLOW_MESSAGES_IDX1) violated
--------

I tried in a workspace that had some existing applications, and a colleague tried
in a new workspace that had just been allocated by APEX.Oracle.com.

I was able to successfully install the Sample Data Loading application after trying to install
the Sample Master Detail packaged application.

Anyone else having this issue?


Thanks in advance!

-Ricky Burke
972-560-3759 Work

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points