Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Designer 2000 Repository Instance Problem

Designer 2000 Repository Instance Problem

From: Tim W. Gallegos <GallegosTW_at_AOL.COM>
Date: Tue, 20 Feb 1996 10:50:01 -0500
Message-Id: <9602201608.AA05006@alice.jcc.com>


Hi all,

Hope someone has seen this, because I've stumped the ORACLE tech support with it. I've just installed the DES2000 Instance with the Rep. Admin. Utility.  After it installed, I verified all the .lis files and all the .log files.  All seems to have installed properly. Then I ran the simply SQL script as recommended in the RAU.TXT file.

SELECT object_type, status, COUNT(*)
FROM user_objects
GROUP BY object_type,status;

I get all the appropriate objects that I'm supposed to get.

When I go to try to create a new application with the Rep. Object Navigator, I get
ORA-06502: PL/SQL: Numeric or value error.

After calling ORACLE tech support, I was sent a script to run that was supposed to "hand crank" the insert of the application. This returned:

Enter value for application name: OUTREACH old 15: app.v.NAME := '&NAME';
new 15: app.v.NAME := 'OUTREACH';
Opening a new activity
Inserting a new Applications System
Operation aborted due to unhandled exceptions RME-00011: Operation 'ins' on APPLICATION_SYSTEM has failed

NAME:                 : OUTREACH

What this script was supposed to tell me was the point of failure. It appears via the script that for some reason APPLICATION_SYSTEM can not be inserted into. Does anyone have any suggestions. REALLY APPRECIATE IT.

Tim Gallegos
Computer Specialist
HORIZON HEALTHCARE Received on Tue Feb 20 1996 - 11:08:15 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US