Solved

Getting started with Designor/2000

Posted on 1998-07-07
4
428 Views
Last Modified: 2008-02-01
After installing Personal Oracle (7.3) I installed (created) the repository. After that I want to create an Application System via the RON.
I can give the application a name and then want to save the application.
Then error RME 00020 appears :
Internal API error ORA-06508 PL/SQL can't find the program.

I guess there must be a stored-procedure in the database.
How to create etc...?

Met vriendelijke groeten,
Jannes
0
Comment
Question by:jannes
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 3

Expert Comment

by:poncejua
ID: 1083263
Make sure the plsql procedure/package exist.  

connect to sqlplus  
select owner, object_name, object_type, status from all_objects
where object_name like 'AK_ORG';
AK_ORG does not exist.  
cd $APPL_TOP/install/
connect to sqlplus as system
run adddls.pls    
    adorgs.pls    
    adddlb.plb
    adorgb.plb    
0
 

Author Comment

by:jannes
ID: 1083264
Where to find these programs ?
adddls.pls / adorgs.pls / adddlb.plb /adorgb.plb

What steps to do for a successfull installation ?
1) install Designer/2000 (version 1.3.2) from CD
2) Start Designer and install a repository
3) @ catproc.sql to create some procedures
.. ??


0
 

Author Comment

by:jannes
ID: 1083265
Problem is solved.
It was a memory problem.


0
 

Accepted Solution

by:
psnana earned 50 total points
ID: 1083266
As Jannes wrote it was a memory problem. Usually whenever we get this type of error , we need to increase the size of the SGA and OPEN CURSORS and Processes to refreain from the further error messages of this kind.
0

Featured Post

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
subtr returning incorrect value 8 93
Oracle Query to Find number of process consumed by a session 15 68
Excess Redo 3 47
construct a query sql 11 42
Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows how to recover a database from a user managed backup

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question