Re: Help required using new Designer install

That tutorial is so lightweight, you're better off spending the same amount of time reading one of the Oracle Press books on Designer.

Van

"Frank" <frankbo_at_interaccess.nl> wrote in message news:8tuhd8$i2b$1_at_porthos.nl.uu.net...
> 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...
> > 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.
> >
> >
> >
>
>
Received on Mon Nov 06 2000 - 00:44:50 CET