Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Designer 2000 Repository Instance Problem
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
![]() |
![]() |