• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 646
  • Last Modified:

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
0
jrobles1232000
Asked:
jrobles1232000
1 Solution
 
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
 
moduloCommented:
PAQed with no points refunded (of 250)

modulo
Community Support Moderator
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

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