[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 447
  • Last Modified:

Getting started with Designor/2000

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
jannes
Asked:
jannes
  • 2
1 Solution
 
poncejuaCommented:
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
 
jannesAuthor Commented:
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
 
jannesAuthor Commented:
Problem is solved.
It was a memory problem.


0
 
psnanaCommented:
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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now