Help using Oracle Designer 6i

From: Ken Harvey <Ken.Harvey_at_iconmedialab.co.uk>
Date: Wed, 8 Nov 2000 15:50:29 -0000
Message-ID: <8ubsgk$gfa$1_at_starburst.uk.insnet.net>

[Quoted] Dear All,

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

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 the Oracle home DEFAULT_HOME at d:\orant, and then 8i into the Oracle home ORA81 at d:\oracle\ora81. Finally I created a repository by following the instructions in the installation guide, and turned on configuration. I did not set up any extra uses and used the repository owner when logging onto designer.

I get an error whenever I try to save an object to the repository. The first example is the error generated when creating a process in the process editor. It occurs when I click on OK to store the process. The second example is the error generated when creating a Relational Table Definition in the Design editor. Again it occurs when I press OK to store the definition.

Do you know what could be wrong,

Thank you for any help,

Ken.

EXAMPLE 1
Message

---

RME-02105: Oracle error occurred...
ORA-06550: line 2, column 11:
PLS-00201: identifier 'CIOFUNCTION.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, column 3:
P

---

---

Message

---

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

pl1_el0.i.ID := true;
pl1_el0.v.ID := :p2_el0;
pl1_el0.i.NUMBER_OF_TIMES_MODIFIED := true;
pl1_el0.v.NUMBER_OF_TIMES_MODIFIED := :p3_el0;
pl1_el0.i.FUNCTION_LABEL := true;
pl1_el0.v.FUNCTION_LABEL := :p4_el0;
pl1_el0.i.SHORT_DEFINITION := true;
pl1_el0.v.SHORT_DEFINITION := :p5_el0;
pl1_el0.i.PARENT_REFERENCE := true;
pl1_el0.v.PARENT_REFERENCE := :p6_el0;
pl1_el0.i.TOTAL_TIME := true;
pl1_el0.v.TOTAL_TIME := :p7_el0;
pl1_el0.i.TOTAL_TIME_UNIT := true;
pl1_el0.v.TOTAL_TIME_UNIT := :p8_el0;
pl1_el0.i.TOTAL_COST_RATE := true;
pl1_el0.v.TOTAL_COST_RATE := :p9_el0;
pl1_el0.i.TOTAL_COST_RATE_UNIT := true;
pl1_el0.v.TOTAL_COST_RATE_UNIT := :p10_el0;
pl1_el0.i.FUNCTION_TYPE := true;
pl1_el0.v.FUNCTION_TYPE := :p11_el0;
pl1_el0.i.WORK_TIME := true;
pl1_el0.v.WORK_TIME := :p12_el0;
pl1_el0.i.WORK_TIME_UNIT := true;
pl1_el0.v.WORK_TIME_UNIT := :p13_el0;
pl1_el0.i.PERSON_COST_RATE := true;
pl1_el0.v.PERSON_COST_RATE := :p14_el0;
pl1_el0.i.PERSON_COST_RATE_UNIT := true;
pl1_el0.v.PERSON_COST_RATE_UNIT := :p15_el0;

CIOFUNCTION.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

---

RME-00222: Failed to dispatch operation to Repository

---

---

EXAMPLE 2
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;
curr_el := 0;

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

---

RME-00222: Failed to dispatch operation to Repository

---

---

Received on Wed Nov 08 2000 - 16:50:29 CET