I am encountering a strange problem with my Oracle 9i DB whereby I get the ORA-06508 program unit being called cannot be found.

I have narrowed this down to a procedure in a package. Whilst I cannot call this procedure succesfully from another procedure getting this error I CAN call it from sql plus directly!!?

Furthermore, restarting the db instance fixes the problem for a little while before it returns again.

All packages are compiled perfectly.

Help appreciated.

Ali