Home » Developer & Programmer » Designer » Designer 6i and CIOORACLE_DATABASE.DATA
Designer 6i and CIOORACLE_DATABASE.DATA [message #80624] Wed, 23 October 2002 00:30 Go to next message
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

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

---------------------------------------------
________________________________________________
Re: Designer 6i and CIOORACLE_DATABASE.DATA [message #81526 is a reply to message #80624] Thu, 27 February 2003 00:42 Go to previous message
prashanth kothur
Messages: 1
Registered: February 2003
Junior Member
hello Mr.Edwin Sosa,

i have read your mail and problem. you said that you have downloaded designer. pl give the address form where you have downloaded designer. i searched through the oracle site & others but i couldn't found. give me the address..
my email : pra_kothur@hotmail.com

thanks..
prashanth kothur.
Previous Topic: What is the Difference Between Oracle Developer and Designer 2000
Next Topic: Oracle Designer with administrative tools
Goto Forum:
  


Current Time: Thu Mar 28 14:33:32 CDT 2024