Solved

Getting started with Designor/2000

Posted on 1998-07-07
4
409 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
  • 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

930 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now