| Designer 6i and CIOORACLE_DATABASE.DATA [message #80624] |
Wed, 23 October 2002 00:30  |
Edwin Sosa
Messages: 1
Registered: October 2002
|
Junior Member |
|
|
Hello,
I have Personal Oracle 8.1.7, Developer 6i and now Designer 6i release 4.4 all installed on Windows 2000 Professional.
I first installed the Server Engine and the Developer tools and worked fine with them for a while. And this week I just downloaded Designer 6i and installed it.
The installation was successfull, as well as the configuration of the repository using the Scripts provided at the REPADM61 directory. I followed the Installation Guide without any problem and everything just worked fine.
Everything seems OK on the Repository Administration Utility.
However, when trying to use Designer I cannot create a Database on it or a Storage Definition or something like that.
I get an error with a PL/SQL statement that tries to use CIOORACLE_DATABASE.DATA datatype. But it is missing. I looked at the Packages and Views and Types for REPOS_MANAGER user and couldn't find such name.
Any ideas? Suggestions?
Thanks in Advance.
Edwin Sosa.
________________________________________________________________________________
The error says:
________________________________________________
Message
-------
RME-02105: Oracle error occurred...
ORA-06550: line 2, column 11:
PLS-00201: identifier 'CIOORACLE_DATABASE.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, colu
--------------------------------------------------------------------------------
Message
-------
RME-02124: Failed to execute SQL statement: declare
pl1_el0 CIOORACLE_DATABASE.data;
utility varchar2(3);
curr_el integer;
begin
savepoint rm_dispatch;
rmmes.clear;
curr_el := 0;
pl1_el0.i.DB_VERSION := true;
pl1_el0.v.DB_VERSION := :p2_el0;
pl1_el0.i.COMPLETE_FLAG := true;
pl1_el0.v.COMPLETE_FLAG := :p3_el0;
pl1_el0.i.TYPES := true;
pl1_el0.v.TYPES := :p4_el0;
pl1_el0.i.REUSE_CONTROL_FILE := true;
pl1_el0.v.REUSE_CONTROL_FILE := :p5_el0;
pl1_el0.i.IRID := true;
pl1_el0.v.IRID := :p6_el0;
pl1_el0.i.DATABASE_TYPE := true;
pl1_el0.v.DATABASE_TYPE := :p7_el0;
pl1_el0.i.SHARED_FLAG := true;
pl1_el0.v.SHARED_FLAG := :p8_el0;
pl1_el0.i.IVID := true;
pl1_el0.v.IVID := :p9_el0;
pl1_el0.i.NUMBER_OF_TIMES_MODIFIED := true;
pl1_el0.v.NUMBER_OF_TIMES_MODIFIED := :p10_el0;
pl1_el0.i.LOCAL_NAME := true;
pl1_el0.v.LOCAL_NAME := :p11_el0;
pl1_el0.i.ID := true;
pl1_el0.v.ID := :p12_el0;
pl1_el0.i.NAME := true;
pl1_el0.v.NAME := :p13_el0;
pl1_el0.i.CHARACTER_SET := true;
pl1_el0.v.CHARACTER_SET := :p14_el0;
pl1_el0.i.ARCHIVE_REDO_LOG_FILES := true;
pl1_el0.v.ARCHIVE_REDO_LOG_FILES := :p15_el0;
CIOORACLE_DATABASE.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
--------------------------------------------------------------------------------
---------------------------------------------
________________________________________________
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
