asked on

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

konektor

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

sapnam

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

ASKER CERTIFIED SOLUTION

modulo

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial