Solved

Error ORA-06508

Posted on 2004-10-13
4
631 Views
Last Modified: 2013-12-12
Hi,

     I'm using Oracle 5.0 and lately I've been getting ORA-06508 error messages. Its a client server application and I'm using Pro-C for my Comms. I tried to debug it and i found out that it's not passing through one of the procedures that I'm trying to call.. When I checked the status of the procedure, its valid.. I tried to kill the process and after killing it, it worked fine.. but after a while it returned back to displaying the same error messages again.. There seems to be no problem with the procedures. What do you think can happen? Could it be a hardware problem (do i need an upgrade in memory)? Btw, the procedures are stored in the database. Are the packages that are stored in the database depended on how much memory is allocated for the packages and procedures? Thanks in advance for any help you can offer.

Jrobles
0
Comment
Question by:jrobles1232000
4 Comments
 
LVL 9

Expert Comment

by:konektor
ID: 12295432
u have to re-connect.

simulate 6508 :
1. logon to your application
2. call the procedure stored in DB - everything will work
3. logon to sqlplus and recompile the procedure
4. call the procedure from application (still connected from step 1) - u'll get ora-6508 and nothinh helps u only reconnecting
0
 
LVL 8

Expert Comment

by:sapnam
ID: 12297612
We had a similar problem.  We dropped the procedures and re-created them and that solved the problem.  You should have the procedure scripts for re-creating them. You can always get that from user_source.  Also, check for any invalid objects before and after dropping as some objects may get invalidated due to object dependency. About memory, that can be an issue. Just post your total RAM on the server and the SGA size to get some idea on this
0
 

Accepted Solution

by:
modulo earned 0 total points
ID: 12563506
PAQed with no points refunded (of 250)

modulo
Community Support Moderator
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

Suggested Solutions

Title # Comments Views Activity
Single ERP VS muttiple Application or Systems 6 64
scheduler for Procedure in DB with 3 arguments in 10g 7 29
oracle 11g 23 50
Create table from select - oracle 6 24
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…
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
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.

920 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

14 Experts available now in Live!

Get 1:1 Help Now