Error ORA-06508

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
jrobles1232000Asked:
Who is Participating?
 
moduloConnect With a Mentor Commented:
PAQed with no points refunded (of 250)

modulo
Community Support Moderator
0
 
konektorCommented:
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
 
sapnamCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.