Re: Help using Oracle Designer 6i

From the looks of it, you miss some packages, synonyms (should not be the case, as you log in as repository owner) or packages are invalid.
I would check the latter first, by using the admin utility; you can recompile invalid objects, or even inspect them.
If these remain invalid, check if all grants needed are given to the repository owner *directly* (that is: not via a role!)

hth

Ken Harvey wrote:

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

--
Gtrz,

Frank van Bortel