Help required using new Designer install

From: Ken Harvey <Ken.Harvey_at_iconmedialab.co.uk>
Date: Fri, 3 Nov 2000 14:11:56 -0000
Message-ID: <8tugrv$74j$1_at_starburst.uk.insnet.net>

[Quoted] Dear All,

I have recently finished installing Designer, Oracle 8i and set up a repository. I came across loads of problems and was delighted to finally get [Quoted] it done. However, my joy did not last for long. I can't get anything to work!

[Quoted] I installed Oracle Designer 6i then Oracle 8i enterprise edition on to a stand alone machine running Windows NT 4.0. I first installed Designer into [Quoted] the Oracle home DEFAULT_HOME at d:\orant, and then 8i into the Oracle home [Quoted] ORA81 at d:\oracle\ora81. Finally I created a repository by following the [Quoted] instructions in the installation guide, and turned on configuration. I did [Quoted] not set up any extra uses and used the repository owner for the following.

[Quoted] I imported the tutorial dump file without any problems. However, when I double click on 'APPLICATION_SYSTEM' I got the following error:

Message

---

ORA-00942: table or view does not exist

---

---

Message

---

ORA-00942: table or view does not exist

---

---

Message

---

RME-02124: Failed to execute SQL statement: select [Quoted] X.irid,X.ivid,X.parent_ivid, Xo.vlabel, Xo.state, X.number_of_times_modified,'N',X.types,X.element_type_name,NULL,jr_icon.get_ icon_name(X.types,X.ivid),'N'
[Quoted] [Quoted] ,decode(Xo.lock_flag,'Y',1,0), Xo.branch_id, bX.name, nvl(Xo.sequence_in_branch,0)
,X.NAME
from i$sdd_object_versions Xo,i$sdd_branches bX, X where X.parent_ivid = Xo.ivid
[Quoted]  and Xo.branch_id = bX.branch_id(+) order by X.NAME

---

---

[Quoted] When ever I create an object I get some kind of error. Fore example, when [Quoted] creating a Relational Table Definition in the Design edition I get the following:

Message

---

RME-02105: Oracle error occurred...
ORA-06550: line 2, column 11:
PLS-00201: identifier 'CIOTABLE_DEFINITION.DATA' must be declared
ORA-06550: line 2, column 11:

PL/SQL: Item ignored
ORA-06550: line 9, column 3:
PLS-00320: the declaration of the type of this expression is incomplete or malformed
ORA-06550: line 9, column 3:
PL/SQL: Statement ignored
ORA-06550: line 10, column 3:
PLS-00320: the declaration of the type of this expression is incomplete or malformed
ORA-06550: line 10, column 3:
PL/SQL: Statement ignored
ORA-06550: line 11, column 3:
PLS-00320: the declaration of the type of this expression is incomplete or malformed
ORA-06550: line 11, column 3:
PL/SQL: Statement ignored
ORA-06550: line 12, column 3:
PLS-00320: the declaration of the type of this expression is incomplete or malformed
ORA-06550: line 12, column 3:
PL/SQL: Statement ignored
ORA-06550: line 13, column 3:
PLS-00320: the declaration of the type of this expression is incomplete or malformed
ORA-06550: line 13, column 3:
PL/SQL: Statement ignored
ORA-06550: line 14, col

---

---

Message

---

RME-02124: Failed to execute SQL statement: declare   pl1_el0 CIOTABLE_DEFINITION.data;
  utility varchar2(3);
  curr_el integer;
begin
  savepoint rm_dispatch;
  rmmes.clear;
[Quoted]   curr_el := 0;

[Quoted]   pl1_el0.i.INDEX_ONLY_FLAG := true;
  pl1_el0.v.INDEX_ONLY_FLAG := :p2_el0;
  pl1_el0.i.COLUMN_PREFIX := true;
  pl1_el0.v.COLUMN_PREFIX := :p3_el0;
  pl1_el0.i.TYPES := true;
  pl1_el0.v.TYPES := :p4_el0;
  pl1_el0.i.IRID := true;
  pl1_el0.v.IRID := :p5_el0;
  pl1_el0.i.IVID := true;
  pl1_el0.v.IVID := :p6_el0;
  pl1_el0.i.NUMBER_OF_TIMES_MODIFIED := true;
  pl1_el0.v.NUMBER_OF_TIMES_MODIFIED := :p7_el0;
  pl1_el0.i.ALIAS := true;
  pl1_el0.v.ALIAS := :p8_el0;
  pl1_el0.i.ID := true;
  pl1_el0.v.ID := :p9_el0;
  pl1_el0.i.NAME := true;
  pl1_el0.v.NAME := :p10_el0;
  pl1_el0.i.JOURNAL_LOCATION := true;
  pl1_el0.v.JOURNAL_LOCATION := :p11_el0;
  pl1_el0.i.DISPLAY_TITLE := true;
  pl1_el0.v.DISPLAY_TITLE := :p12_el0;

  CIOTABLE_DEFINITION.INS(:p1_el0,pl1_el0);
:errcnt := 0;

exception when others then
  rmmes.get_error_state(utility,:excode);   rmmes.get_product(utility,:exprod);
:exutil := utility;
:errcnt := rmmes.getsize;
:sqlcod := SQLCODE;
:sqlmsg := SQLERRM;
:currel := curr_el;

  rollback to savepoint rm_dispatch;
end;

---

---

Message

---

[Quoted] RME-00222: Failed to dispatch operation to Repository

---

---

[Quoted] Any help would be very much appreciated.

Thanks,

Ken. Received on Fri Nov 03 2000 - 15:11:56 CET