Re: Help required using new Designer install
From: Frank <frankbo_at_interaccess.nl>
Date: Fri, 3 Nov 2000 15:16:45 +0100
Message-ID: <8tuhd8$i2b$1_at_porthos.nl.uu.net>
Date: Fri, 3 Nov 2000 15:16:45 +0100
Message-ID: <8tuhd8$i2b$1_at_porthos.nl.uu.net>
[Quoted] Was the tutorial user defined in the Admin Utility, and reconciled (only if you did not opt for public synonyms)
-- Frank Ken Harvey <Ken.Harvey_at_iconmedialab.co.uk> schreef in berichtnieuws 8tugrv$74j$1_at_starburst.uk.insnet.net...Received on Fri Nov 03 2000 - 15:16:45 CET
> 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
> 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 for the following.
>
> 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
> 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'
> ,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
> and Xo.branch_id = bX.branch_id(+) order by X.NAME
>
> --------------------------------------------------------------------------
--
> ----
>
>
>
>
> When ever I create an object I get some kind of error. Fore example, when
> 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;
> 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
>
> --------------------------------------------------------------------------
--
> ----
>
>
>
> Any help would be very much appreciated.
>
> Thanks,
>
> Ken.
>
>
>