Help required using new Designer install
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