Home » Developer & Programmer » Designer » Error using Designer6i
icon9.gif  Error using Designer6i [message #131415] Fri, 05 August 2005 16:40
aramatos
Messages: 3
Registered: August 2005
Location: Santos - Brasil
Junior Member
Hi, and thanks, I installed designer6i and the repository error-free but when I go to use designer I do not obtain to create table or procedures, the system returns me
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

Cause
-----
An unhandled oracle error has occurred.


Action
------
Examine reported errors for specific details.


--------------------------------------------------------------------------------

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.DATA_PERSISTENCE := true;
pl1_el0.v.DATA_PERSISTENCE := :p4_el0;
pl1_el0.i.TYPES := true;
pl1_el0.v.TYPES := :p5_el0;
pl1_el0.i.IRID := true;
pl1_el0.v.IRID := :p6_el0;
pl1_el0.i.IVID := true;
pl1_el0.v.IVID := :p7_el0;
pl1_el0.i.NUMBER_OF_TIMES_MODIFIED := true;
pl1_el0.v.NUMBER_OF_TIMES_MODIFIED := :p8_el0;
pl1_el0.i.ALIAS := true;
pl1_el0.v.ALIAS := :p9_el0;
pl1_el0.i.ID := true;
pl1_el0.v.ID := :p10_el0;
pl1_el0.i.NAME := true;
pl1_el0.v.NAME := :p11_el0;
pl1_el0.i.JOURNAL_LOCATION := true;
pl1_el0.v.JOURNAL_LOCATION := :p12_el0;
pl1_el0.i.DISPLAY_TITLE := true;
pl1_el0.v.DISPLAY_TITLE := :p13_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;

Cause
-----
An error occurred while executing a SQL statement.


Action
------
Examine reported errors for specific details.


--------------------------------------------------------------------------------

Message
-------
RME-00222: Failed to dispatch operation to Repository

Cause
-----
Requested operation failed because of other errors.


Action
------
Examine other reported errors for specific details.


--------------------------------------------------------------------------------
what's the problems?

Previous Topic: inheritance in table design
Next Topic: Des 6i r4.11 runs on oracle 9i r2.0 ???
Goto Forum:
  


Current Time: Wed Sep 30 14:54:46 CDT 2020